8.6 Bitwise Functions
8.6.1 BIN_AND()
Available inDSQL, PSQL
Possible name conflictYES → Read details
Syntax
BIN_AND (number, number [, number ...])
BIN_AND Function Parameters| Parameter | Description |
|---|---|
number | Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0) |
Result typeSMALLINT, 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.
DescriptionReturns the result of the bitwise AND operation on the argument(s).
8.6.2 BIN_NOT()
Available inDSQL, PSQL
Possible name conflictNO
Syntax
BIN_NOT (number)
BIN_NOT Function Parameter| Parameter | Description |
|---|---|
number | Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0) |
Result typeSMALLINT, 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.
DescriptionReturns the result of the bitwise NOT operation on the argument, i.e. ones complement.
See alsoSection 8.6.3, BIN_OR(), Section 8.6.6, BIN_XOR() and others in this set.
8.6.3 BIN_OR()
Available inDSQL, PSQL
Possible name conflictYES → Read details
Syntax
BIN_OR (number, number [, number ...])
BIN_OR Function Parameters| Parameter | Description |
|---|---|
number | Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0) |
Result typeSMALLINT, 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.
DescriptionReturns the result of the bitwise OR operation on the argument(s).
8.6.4 BIN_SHL()
Available inDSQL, PSQL
Syntax
BIN_SHL (number, shift)
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 typeBIGINT
DescriptionReturns the first argument bitwise left-shifted by the second argument, i.e. a << b or a·2b.
See alsoSection 8.6.5, BIN_SHR()
8.6.5 BIN_SHR()
Available inDSQL, PSQL
Syntax
BIN_SHR (number, shift)
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 typeBIGINT
DescriptionReturns 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 alsoSection 8.6.4, BIN_SHL()
8.6.6 BIN_XOR()
Available inDSQL, PSQL
Possible name conflictYES → Read details
Syntax
BIN_XOR (number, number [, number ...])
BIN_XOR Function Parameters| Parameter | Description |
|---|---|
number | Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0) |
Result typeSMALLINT, 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.
DescriptionReturns the result of the bitwise XOR operation on the argument(s).