Bitwise Functions

Valentina has set of functions to do bit operations. On default 64-bit arithmetic is used.

Returns the bit AND for arguments X and Y.

SELECT BIT_AND( 29, 15 );
=> 13

Returns the bit OR for arguments X and Y.

SELECT BIT_OR( 29, 15 );
=> 31

Returns the bit XOR for arguments X and Y.

SELECT BIT_XOR( 1, 1 );
=> 0
 
SELECT BIT_XOR( 1, 0 );
=> 1

Returns the inverted bits of argument X.

SELECT BIT_NOT( BIT_NOT(5) );
=> 5

Returns the count of bits that are set in the argument X.

SELECT BIT_COUNT( 5 );
=> 2

Shifts bits of the argument X to the left.

SELECT 1 << 3
=> 8

Shifts bits of the argument X to the right.

SELECT 8 >> 3
=> 1