Re: [GENERAL] exclusive OR possible within a where clause?

[John R Pierce]

On 10/17/11 12:40 PM, David Salisbury wrote:

 something
-----------
         1
         2

select * from test where ( something = 1.5 + .5 ) .XOR. ( something = 1.5 - .5 );

well,   something[1] = 1, so thats FALSE .XOR. TRUE, which is TRUE
and, something[2] = 2, so thats TRUE .XOR. FALSE, which is also TRUE

no?




--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general