Re: exclusive OR possible within a where clause?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: exclusive OR possible within a where clause?
Date: 2011-10-17 20:12:07
Message-ID: 4E9C8C17.7050001@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Salisbury 2011-10-17 20:27:21 Re: exclusive OR possible within a where clause?
Previous Message David Salisbury 2011-10-17 19:40:32 Re: exclusive OR possible within a where clause?