8.6. Bitwise Functions
8.6.1. BIN_AND()
Bitwise AND
Result typeinteger type (the widest type of the arguments)
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.
Syntax
|BIN_AND (number, number [, number ...])
BIN_AND Function Parameters| Parameter | Description |
|---|---|
number | A number of an integer type |
Returns the result of the bitwise AND operation on the argument(s).
See alsoSection 8.6.3, “BIN_OR()”, Section 8.6.6, “BIN_XOR()”
8.6.2. BIN_NOT()
Bitwise NOT
Result typeinteger type matching the argument
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.
Syntax
|BIN_NOT (number)
BIN_NOT Function Parameter| Parameter | Description |
|---|---|
number | A number of an integer type |
Returns the result of the bitwise NOT operation on the argument, i.e. one’s complement.
See alsoSection 8.6.3, “BIN_OR()”, Section 8.6.6, “BIN_XOR()” and others in this set.
8.6.3. BIN_OR()
Bitwise OR
Result typeinteger type (the widest type of the arguments)
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.
Syntax
|BIN_OR (number, number [, number ...])
BIN_OR Function Parameters| Parameter | Description |
|---|---|
number | A number of an integer type |
Returns the result of the bitwise OR operation on the argument(s).
See alsoSection 8.6.1, “BIN_AND()”, Section 8.6.6, “BIN_XOR()”
8.6.4. BIN_SHL()
Bitwise left-shift
Result typeBIGINT or INT128 depending on the first argument
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 |
Returns 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()
Bitwise right-shift with sign extension
Result typeBIGINT or INT128 depending on the first argument
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 |
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 (x86 SAR), meaning that the sign of the first operand is always preserved.
See alsoSection 8.6.4, “BIN_SHL()”
8.6.6. BIN_XOR()
Bitwise XOR
Result typeinteger type (the widest type of the arguments)
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.
Syntax
|BIN_XOR (number, number [, number ...])
BIN_XOR Function Parameters| Parameter | Description |
|---|---|
number | A number of an integer type |
Returns the result of the bitwise XOR operation on the argument(s).
See alsoSection 8.6.1, “BIN_AND()”, Section 8.6.3, “BIN_OR()”