Re: Difference between "foo is false" and "foo=false"? Partial index on boolean.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Difference between "foo is false" and "foo=false"? Partial index on boolean.
Дата
Msg-id 14040.1188881806@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Difference between "foo is false" and "foo=false"? Partial index on boolean.  (Bryce Nesbitt <bryce1@obviously.com>)
Ответы Re: Difference between "foo is false" and "foo=false"? Partial index on boolean.  (Bryce Nesbitt <bryce1@obviously.com>)
Список pgsql-sql
Дерево обсуждения 
Bryce Nesbitt <bryce1@obviously.com> writes:
> Could someone explain
> the difference between "foo=false" and "foo is false", for a boolean
> type column?

They give different results for NULL --- specifically, NULL for the
former and FALSE for the latter.  Don't blame me, it's in the spec...
        regards, tom lane

В списке pgsql-sql по дате отправления:

Предыдущее
От: Bryce Nesbitt
Дата:
Сообщение: Difference between "foo is false" and "foo=false"? Partial index on boolean.
Следующее
От: Bryce Nesbitt
Дата:
Сообщение: Re: Difference between "foo is false" and "foo=false"? Partial index on boolean.