6.7. Bitwise Functions

bitcount(_x, bits) → bigint

Count the number of bits set in x (treated as bits-bit signedinteger) 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

bitwiseand(_x, y) → bigint

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

bitwisenot(_x) → bigint

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

bitwiseor(_x, y) → bigint

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

bitwisexor(_x, y) → bigint

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

原文: https://prestodb.io/docs/current/functions/bitwise.html