bit_count
Count the number of bits set in x (treated as bits-bit signed integer) in 2’s complement representation.
Supported Signatures
function bit_count(bigint, bigint) returns bigint
🔗 Official Documentation
bitwise_and
Returns the bitwise AND of x and y in 2’s complement representation.
Supported Signatures
function bitwise_and(bigint, bigint) returns bigint
🔗 Official Documentation
bitwise_left_shift
Returns the left shifted value of value.
Supported Signatures
function bitwise_left_shift(bigint, bigint) returns bigint
function bitwise_left_shift(integer, bigint) returns integer
function bitwise_left_shift(smallint, bigint) returns smallint
function bitwise_left_shift(tinyint, bigint) returns tinyint
🔗 Official Documentation
bitwise_not
Returns the bitwise NOT of x in 2’s complement representation (NOT x = -x - 1).
Supported Signatures
function bitwise_not(bigint) returns bigint
🔗 Official Documentation
bitwise_or
Returns the bitwise OR of x and y in 2’s complement representation.
Supported Signatures
function bitwise_or(bigint, bigint) returns bigint
🔗 Official Documentation
bitwise_right_shift
Returns the logical right shifted value of value.
Supported Signatures
function bitwise_right_shift(bigint, bigint) returns bigint
function bitwise_right_shift(integer, bigint) returns integer
function bitwise_right_shift(smallint, bigint) returns smallint
function bitwise_right_shift(tinyint, bigint) returns tinyint
🔗 Official Documentation
bitwise_right_shift_arithmetic
Returns the arithmetic right shifted value of value.
Supported Signatures
function bitwise_right_shift_arithmetic(bigint, bigint) returns bigint
function bitwise_right_shift_arithmetic(integer, bigint) returns integer
function bitwise_right_shift_arithmetic(smallint, bigint) returns smallint
function bitwise_right_shift_arithmetic(tinyint, bigint) returns tinyint
🔗 Official Documentation
bitwise_xor
Returns the bitwise XOR of x and y in 2’s complement representation.
Supported Signatures
function bitwise_xor(bigint, bigint) returns bigint
🔗 Official Documentation
