~ (bitwise NOT)
Returns the bitwise NOT (negation) of two numeric expressions. This is the bitwise complement.
Syntax
~ expr --> integer
expr ::= integer
Arguments
Parameter |
Description |
|---|---|
|
Integer expression |
Returns
Returns an integer that is the bitwise NOT of the input.
Notes
If the value is NULL, the result is NULL.
Examples
master=> SELECT ~16, ~24;
-17,-25
master=> SELECT ~101, ~110;
-102,-111
master=> SELECT ~32, ~64;
-33,-65
master=> CREATE TABLE bit(b1 int, b2 int, b3 int);
executed
master=> INSERT INTO bit VALUES (1,2,3), (2, 4, 6), (4, 2, 6), (2, 8, 16), (null, null, 64), (5, 3, 1), (6, 1, 0);
executed
SELECT b1, b2, b3, ~b1, ~b2, ~b3 FROM bit;
b1 | b2 | b3 | ?column? | ?column?0 | ?column?1
---+----+----+----------+-----------+----------
1 | 2 | 3 | -2 | -3 | -4
2 | 4 | 6 | -3 | -5 | -7
4 | 2 | 6 | -5 | -3 | -7
2 | 8 | 16 | -3 | -9 | -17
| | 64 | | | -65
5 | 3 | 1 | -6 | -4 | -2
6 | 1 | 0 | -7 | -2 | -1