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. |