## BITXOR()

BITXOR() — Returns the mask of bits set in one but not both of two BIGINT
values

## Description

The BITXOR() function returns the mask of bits set in one but not
both of two BIGINT integers. In other words, it performs a bitwise XOR
operation on the two arguments. The result is returned as a new BIGINT
value — the arguments to the function are not modified.

The left-most bit of an integer number is the sign bit, but has no
special meaning for bitwise operations. However, The left-most bit set to
1 followed by all zeros is reserved as the NULL value. If you use a NULL
value as an argument, you will receive a NULL response. But in all other
circumstances (using non-NULL BIGINT arguments), the bitwise functions
should never return a NULL result. Consequently any bitwise operation that
would result in only the left-most bit being set, will generate an error
at runtime.

## Examples

The following example writes values into two BIGINT columns of the
table *bits* and then returns the bitwise XOR of
the columns: