Bitwise expression functions¶

This family of functions can be used to perform bitwise operations on numbers or a group of numeric records.

Function Name	Syntax	Summary Description
BITAND	`BITAND(a, b)`	Bitwise AND of two numeric or binary expressions (`a` and `b`).
BITAND_AGG	`BITAND_AGG(a)`	Bitwise AND value of all non-NULL numeric records in a group `a`.
BITNOT	`BITNOT(a)`	Bitwise negation of `a` numeric or binary expression.
BITOR	`BITOR(a, b)`	Bitwise OR of two numeric or binary expressions (`a` and `b`).
BITOR_AGG	`BITOR_AGG(a)`	Bitwise OR value of all non-NULL numeric records in a group `a`.
BITSHIFTLEFT	`BITSHIFTLEFT(a, n)`	Shift the bits for `a` numeric or binary expression `n` positions to the left.
BITSHIFTRIGHT	`BITSHIFTRIGHT(a, n)`	Shift the bits for `a` numeric or binary expression `n` positions to the right, with sign extension.
BITXOR	`BITXOR(a, b)`	Bitwise XOR of two numeric or binary expressions (`a` and `b`).
BITXOR_AGG	`BITXOR_AGG(a)`	Bitwise XOR value of all non-NULL numeric records in a group `a`.
GETBIT	`GETBIT(a, n)`	Return the bit at position `n` in `a` numeric expression.