Bitwise Expression Functions

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

Function Name Expression Summary Description
BITAND BITAND(a, b) Bitwise AND of two number expressions.
BITAND_AGG BITAND_AGG(a) Same as BITAND, expect for all numeric records in group a.
BITNOT BITNOT(a) Bitwise negation of a number expression.
BITOR BITOR(a, b) Bitwise OR of two number expressions.
BITOR_AGG BITOR_AGG(a) Same as BITOR, expect for all numeric records in group a.
BITSHIFTLEFT BITSHIFTLEFT(a, n) Shift the bits for a number expression n positions to the left.
BITSHIFTRIGHT BITSHIFTRIGHT(a, n) Shift the bits for a number expression n positions to the right, with sign extension.
BITXOR BITXOR(a, b) Bitwise XOR of two number expressions.
BITXOR_AGG BITXOR_AGG(a) Same as BITXOR, except for all numeric records in group a.