Re: Type conversions and nulls

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Type conversions and nulls
Дата
Msg-id 19329.1084331756@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Type conversions and nulls  (Edmund Dengler <edmundd@eSentire.com>)
Список pgsql-general
Edmund Dengler <edmundd@eSentire.com> writes:
> What I want is an '=' that compares nulls as equal (rather than as
> not-equal, which is the normal case).

IS DISTINCT FROM may help you here.  It's a not-equals operator rather
than an equals operator, but it does what you want.

(Unless what you wanted included being able to use an index...)

            regards, tom lane

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

Предыдущее
От: Rachel McConnell
Дата:
Сообщение: Re: template1, createdb, schemas, and owners
Следующее
От: Daniel Fitzgerald
Дата:
Сообщение: Need a hardware optimization pointer