Re: exclusive OR possible within a where clause?

Поиск
Список
Период
Сортировка
От David Salisbury
Тема Re: exclusive OR possible within a where clause?
Дата
Msg-id 4E9C8FA9.8040203@globe.gov
обсуждение исходный текст
Ответ на Re: exclusive OR possible within a where clause?  (John R Pierce <pierce@hogranch.com>)
Список 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: exclusive OR possible within a where clause?
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: exclusive OR possible within a where clause?