BITWISE_NOT()

All functions > BITWISE > BITWISE_NOT()

Returns the bitwise NOT (complement) of a bitstring, flipping every bit.

Signatures

Returns: Bitwise complement, or NULL if the input is NULL

BITWISE_NOT(expr: BITSTRING) → BITSTRING

Notes

• Every 0 becomes 1 and every 1 becomes 0
• The length of the result is the same as the input
• Returns NULL if the input is NULL

Related operators

• Bitwise NOT

Examples

SELECT
    f1 := BITWISE_NOT('1010'::BITSTRING)::VARCHAR -- Flip all bits
;