Bitwise OR
All functions > BITWISE > Bitwise OR
Returns the bitwise OR of two bitstrings.
Syntax
left | right · BITWISE_OR(left, right)
Notes
- Both operands must have the same length
- Each bit position is ORed independently: 0 OR 0 = 0, all other combinations = 1
- Returns NULL if either input is NULL
Related Functions
Examples
BITWISE_OR(...)
FeatureQL
SELECT
-- Complementary bits produce all 1s
f1 := BITWISE_OR('1010'::BITSTRING, '0101'::BITSTRING)::VARCHAR,
-- Non-overlapping bits
f2 := BITWISE_OR('1100'::BITSTRING, '0011'::BITSTRING)::VARCHAR,
-- OR with zero preserves bits
f3 := BITWISE_OR('1000'::BITSTRING, '0000'::BITSTRING)::VARCHAR
;Result
| f1 VARCHAR | f2 VARCHAR | f3 VARCHAR |
|---|---|---|
| 1111 | 1111 | 1000 |
Operator |
FeatureQL
SELECT
-- Complementary bits produce all 1s
f1 := ('1010'::BITSTRING | '0101'::BITSTRING)::VARCHAR,
-- Non-overlapping bits
f2 := ('1100'::BITSTRING | '0011'::BITSTRING)::VARCHAR,
-- OR with zero preserves bits
f3 := ('1000'::BITSTRING | '0000'::BITSTRING)::VARCHAR
;Result
| f1 VARCHAR | f2 VARCHAR | f3 VARCHAR |
|---|---|---|
| 1111 | 1111 | 1000 |