Re: exclusive OR possible within a where clause? - Mailing list pgsql-general

From David Salisbury
Subject Re: exclusive OR possible within a where clause?
Date
Msg-id 4E9C8FA9.8040203@globe.gov
Whole thread Raw
In response to Re: exclusive OR possible within a where clause?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general

On 10/17/11 2:12 PM, John R Pierce wrote:
> 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?
>

Ah yes.  I'm seeing the folly of my ways now (Doh!).

Distinct it is.

Thanks!

-ds

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: exclusive OR possible within a where clause?
Next
From: "David Johnston"
Date:
Subject: Re: exclusive OR possible within a where clause?