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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
