xor()

Bitwise XOR

Reference: DuckDB 2.0.0

Arguments & returns

11 overloads

xor(left, right)

Scalar
Overload link leftright Returns
#01 BIGINTBIGINT BIGINT
#02 BITBIT BIT
#03 HUGEINTHUGEINT HUGEINT
#04 INTEGERINTEGER INTEGER
#05 SMALLINTSMALLINT SMALLINT
#06 TINYINTTINYINT TINYINT
#07 UBIGINTUBIGINT UBIGINT
#08 UHUGEINTUHUGEINT UHUGEINT
#09 UINTEGERUINTEGER UINTEGER
#10 USMALLINTUSMALLINT USMALLINT
#11 UTINYINTUTINYINT UTINYINT

Example

xor example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Engine example ยท Run to view results.

In other engines

PostgreSQL

a # b
In DuckDB
XOR(a, b)

SQLGlot example โ†—

BigQuery

a ^ b
In DuckDB
XOR(a, b)

SQLGlot example โ†—

Exasolbit_xor()

SELECT BIT_XOR(x, 1)
In DuckDB
SELECT XOR(x, 1)

SQLGlot example โ†—

Prestobitwise_xor()

BITWISE_XOR(a, b)
In DuckDB
XOR(a, b)

SQLGlot example โ†—