XOR operator.
On Fri, 28 Mar 2003, Joshua Moore-Oliva wrote:
Does postgresql support the xor operator?
You can get bitwise/binary xor (of bitstrings and integers) with the #
operator AFAICS.
AFAICR
A xor B = ( A and not B) or ( not A and B)
It is a pain to write, but you can always:
CREATE FUNCTION XOR( boolean, boolean)
RETURNS boolean as '
RETURN ( $1 and not $2) or ( not $1 and $2);
' LANGUAGE 'plpgsql';
Stephan Szabo wrote:
Show quoted text
On Fri, 28 Mar 2003, Joshua Moore-Oliva wrote:
Does postgresql support the xor operator?
You can get bitwise/binary xor (of bitstrings and integers) with the #
operator AFAICS.---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)