Logical operators
 

Hey,

Can someone tell me if PostgreSQL supports the logical operator XOR?

Thanx

Nikitas Stamatopoulos

Use the doc, Luke!

http://www.postgresql.org/docs/7.4/s...ions-math.html

The tutorial you gave me a link to just mentions that there is support for the bitwise XOR operator not the logical XOR operator. They are different things. Anyway, as it turns out, PostgreSQL DOES NOT support the XOR logical operator.

cheers,

Nikitas Stamatopoulos

It did
 

# bitwise XOR 17 # 5

It didn't
 

Ok, logic operators are either value operations or bitwise operations. Bitwise operations consider the individual bits separately unlike the value operations that treat the while value as an entity. And when you don't specify bitwise operator, you assume it's the value operation. So, PostgreSQL DOES NOT SUPPORT the XOR value operator. Check this manual and tell me if you think differently:

manual