Bitwise Functions

bit_count(x, bits) bigint

Count the number of bits set in x (treated as bits-bit signed integer) in 2’s complement representation:

SELECT bit_count(9, 64); -- 2
SELECT bit_count(9, 8); -- 2
SELECT bit_count(-7, 64); -- 62
SELECT bit_count(-7, 8); -- 6
bitwise_and(x, y) [bigint]

Returns the bitwise AND of x and y in 2’s complement representation.

bitwise_arithmetic_shift_right(x, shift) [bigint]``

Returns the arithmetic right shift operation on x shifted by shift in 2’s complement representation. shift must not be negative.

bitwise_left_shift(x, shift) [bigint]``

Returns the left shifted value of x. Here x can be of type TINYINT , SMALLINT, INTEGER and BIGINT.

bitwise_logical_shift_right(x, shift, bits) [bigint]``

Returns the logical right shift operation on x (treated as bits-bit integer) shifted by shift. shift must not be negative.

bitwise_not(x) [bigint]

Returns the bitwise NOT of x in 2’s complement representation.

bitwise_or(x, y) [bigint]

Returns the bitwise OR of x and y in 2’s complement representation.

bitwise_right_shift(x, shift) [bigint]``

Returns the logical right shifted value of x. Here x can be of type TINYINT, SMALLINT, INTEGER and BIGINT.

bitwise_right_shift_arithmetic(x, shift) [bigint]``

Returns the arithmetic right shift value of x.

bitwise_shift_left(x, shift, bits) [bigint]``

Returns the left shift operation on x (treated as bits-bit integer) shifted by shift. shift must not be negative.

bitwise_xor(x, y) [bigint]``

Returns the bitwise XOR of x and y in 2’s complement representation.