BIT_XOR

​

Syntax

​

Aggregate

bit_xor([DISTINCT] value)

​

Window

bit_xor(value) OVER ([PARTITION BY key] [ORDER BY ordering_key] [ROWS frame])

• RANGE frames with a numeric or time offset are not supported. Use unique ORDER BY values for calculations that advance one row at a time. DISTINCT is not supported in these window forms.

​

Arguments

​

Aggregate and window

​

Returns

• Type: Same SQL type as value
• NULL behavior: NULLs are ignored; an all-NULL group or frame returns NULL.
• Empty input: Returns NULL on an empty global aggregate or empty frame.

​

Properties

​

Usage notes

• Use DISTINCT in grouped aggregation only. It does not provide duplicate removal in a window call.

​

Examples

​

Combine bits

WITH t("value") AS (VALUES (3), (5)) SELECT bit_xor("value") AS result FROM t;

​

Ignore NULLs

WITH t("value") AS (VALUES (1), (CAST(NULL AS INTEGER)), (2)) SELECT bit_xor("value") AS result FROM t;

​

All NULL values

WITH t("value") AS (VALUES (CAST(NULL AS INTEGER)), (CAST(NULL AS INTEGER))) SELECT bit_xor("value") AS result FROM t;

​

Limitations

• BIT_XOR does not support DISTINCT in sliding windows.