bit_xor()
A function for computing the bitwise exclusive OR of input values
This entry relates to a PostgreSQL feature which is part of PostgreSQL 14, due to be released in late 2021.
bit_xor() is a system function for computing the bitwise exclusive OR of all non-null input values.
bit_xor() was added in PostgreSQL 14.
Usage
bit_xor ( smallint ) → smallint bit_xor ( integer ) → integer bit_xor ( bigint ) → bigint bit_xor ( bit ) → bit
bit_xor() in other databases
- DB2: BIT_XOR routine
- MySQL: BIT_XOR(expr) [over_clause]
- MariaDB: BIT_XOR
Change history
- PostgreSQL 14
- added (commit f9a0392e)
References
- PostgreSQL 14 documentation: General-Purpose Aggregate Functions