8. Built-in Functions - 8.6. Bitwise Functions - 《Firebird 2.5 Language Reference》

8.6. Bitwise Functions

8.6. Bitwise Functions

8.6.1. `BIN_AND()`

Available in

DSQL, PSQL

Possible name conflict

Syntax

BIN_AND (number, number [, number ...])

Table 147. `BIN_AND` Function Parameters
Parameter	Description
number	Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0)

Result type

SMALLINT, INTEGER or BIGINT

SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) with n <= 4; otherwise small integers return an INTEGER result.

Description

Returns the result of the bitwise AND operation on the argument(s).

See also

BIN_OR(), BIN_XOR()

8.6.2. `BIN_NOT()`

Available in

DSQL, PSQL

Possible name conflict

Syntax

BIN_NOT (number)

Table 148. `BIN_NOT` Function Parameter
Parameter	Description
number	Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0)

Result type

SMALLINT, INTEGER or BIGINT

SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) with n <= 4; otherwise small integers return an INTEGER result.

Description

Returns the result of the bitwise NOT operation on the argument, i.e. ones complement.

See also

BIN_OR(), BIN_XOR() and others in this set.

8.6.3. `BIN_OR()`

Available in

DSQL, PSQL

Possible name conflict

YES → Read details

Syntax

BIN_OR (number, number [, number ...])

Table 149. `BIN_OR` Function Parameters
Parameter	Description
number	Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0)

Result type

SMALLINT, INTEGER or BIGINT

SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) with n <= 4; otherwise small integers return an INTEGER result.

Description

Returns the result of the bitwise OR operation on the argument(s).

See also

BIN_AND(), BIN_XOR()

8.6.4. `BIN_SHL()`

Available in

DSQL, PSQL

Syntax

BIN_SHL (number, shift)

Table 150. `BIN_SHL` Function Parameters
Parameter	Description
number	A number of an integer type
shift	The number of bits the number value is shifted by

Result type

BIGINT

Description

Returns the first argument bitwise left-shifted by the second argument, i.e. a << b or a·2b.

See also

BIN_SHR()

8.6.5. `BIN_SHR()`

Available in

DSQL, PSQL

Syntax

BIN_SHR (number, shift)

Table 151. `BIN_SHR` Function Parameters
Parameter	Description
number	A number of an integer type
shift	The number of bits the number value is shifted by

Result type

BIGINT

Description

Returns the first argument bitwise right-shifted by the second argument, i.e. a >> b or a/2b.

The operation performed is an arithmetic right shift (SAR), meaning that the sign of the first operand is always preserved.

See also

BIN_SHL()

8.6.6. `BIN_XOR()`

Available in

DSQL, PSQL

Possible name conflict

YES → Read details

Syntax

BIN_XOR (number, number [, number ...])

Table 152. `BIN_XOR` Function Parameters
Parameter	Description
number	Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0)

Result type

SMALLINT, INTEGER or BIGINT

SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) with n <= 4; otherwise small integers return an INTEGER result.

Description

Returns the result of the bitwise XOR operation on the argument(s).

See also

BIN_AND(), BIN_OR()