Re: exclusive OR possible within a where clause? - Mailing list 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