BIT_OR

Returns the bitwise OR of two bitstrings.

Signatures

Returns: Bitwise OR of the two operands

BIT_OR(left: BITSTRING, right: BITSTRING) → BITSTRING

sql

Parameter	Type	Required	Description
`left`	`BITSTRING`	Yes	First bitstring operand
`right`	`BITSTRING`	Yes	Second bitstring operand

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

Examples

FeatureQL

SELECT
    f1 := BIT_OR('1010'::BITSTRING, '0101'::BITSTRING)::VARCHAR,  -- Complementary bits produce all 1s
    f2 := BIT_OR('1100'::BITSTRING, '0011'::BITSTRING)::VARCHAR,  -- Non-overlapping bits
    f3 := BIT_OR('1000'::BITSTRING, '0000'::BITSTRING)::VARCHAR,  -- OR with zero preserves bits
    f4 := ('1010'::BITSTRING | '0101'::BITSTRING)::VARCHAR  -- Operator syntax: | for OR
;

Result

f1 VARCHAR	f2 VARCHAR	f3 VARCHAR	f4 VARCHAR
1111	1111	1000	1111

Suggest changes to this page

Last update at: 2026/03/18 16:18:57

On this page

Signatures Notes Examples