Bitwise functions#
-
bit_count(x, bits) → bigint# Count the number of bits set in
x(treated asbits-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
xandyin 2’s complement representation.
-
bitwise_not(x) → bigint# Returns the bitwise NOT of
xin 2’s complement representation.
-
bitwise_or(x, y) → bigint# Returns the bitwise OR of
xandyin 2’s complement representation.
-
bitwise_xor(x, y) → bigint# Returns the bitwise XOR of
xandyin 2’s complement representation.
-
bitwise_left_shift(value, shift) → [same as value]# Returns the left shifted value of
value.
-
bitwise_right_shift(value, shift, digits) → [same as value]# Returns the logical right shifted value of
value.
-
bitwise_right_shift_arithmetic(value, shift) → [same as value]# Returns the arithmetic right shifted value of
value.
See also bitwise_and_agg() and bitwise_or_agg().