Bitwise Functions

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