Re: exclusive OR possible within a where clause?

From: David Salisbury <salisbury(at)globe(dot)gov>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: exclusive OR possible within a where clause?
Date: 2011-10-17 20:27:21
Message-ID: 4E9C8FA9.8040203@globe.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-10-17 20:28:54 Re: exclusive OR possible within a where clause?
Previous Message John R Pierce 2011-10-17 20:12:07 Re: exclusive OR possible within a where clause?