Reference: Bit String Types
CedarDB supports the standard SQL bit-string data types bit(n) and bit varying(n), where n specifies the number of
bits in the bit string.
Bit strings can be specified with binary or hex digits: b'1010' == x'a'.
Usage Example
create table example (
bits bit varying
);
insert into example
values (b'00000000'), (x'ff'), (b'10101010'), (x'cafebabe');
select * from example; bits
----------------------------------
00000000
11111111
10101010
11001010111111101011101010111110
(4 rows)Operators
| Operator | Description | Example | Result |
|---|---|---|---|
|| | Concatenation | B'10' || B'01' | 1001 |
& | Bitwise AND | B'1010' & B'0110' | 0010 |
| | Bitwise OR | B'1010' | B'0101' | 1111 |
# | Bitwise XOR | B'1010' # B'0110' | 1100 |
For functions on bit strings, such as length, bit_count, get_bit, and set_bit, see bit string functions.
PostgreSQL Differences
- The bitwise NOT operator
~and the shift operators<<and>>are not supported for bit strings.
