From: | Nagib Abi Fadel <nagib_postgres(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | XOR logical operator |
Date: | 2003-10-17 08:04:48 |
Message-ID: | 20031017080448.23789.qmail@web21403.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Is there a XOR logical operator in Postgresql, or a
function for XOR ??
I only found in the docs a Binary XOR (#).
I need to do the following checkup:
(field1 is NULL XOR field2 is NULL XOR filed3 is NULL)
i can't right it like this:
(
(field1 is NUll or field2 is NUll)
and (field1 is NUll or field3 is NUll)
and (field2 is NUll or field3 is NUll)
)
But if i have alot of fields :
field1,field2,...,field5
... this will take a hell of a time
I can write a function F1 that does the following:
if a field is NULL it will return 1
else it will return 0
then i can do:
(F1(field1) # F1(field2) # F1(field3) ...)
but i just wanted to see if XOR already exists ...
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2003-10-17 08:12:49 | Re: XOR logical operator |
Previous Message | Sharon Cowling | 2003-10-17 04:08:00 | Disabling referential integrity |