Re: Type conversions and nulls

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Type conversions and nulls
Дата
в 00:16:24
Msg-id
19329.1084331756@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Type conversions and nulls Edmund Dengler <edmundd@eSentire.com>
Re: Type conversions and nulls Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: Type conversions and nulls Edmund Dengler <edmundd@eSentire.com>
Re: Type conversions and nulls "scott.marlowe" <scott.marlowe@ihs.com>
Re: Type conversions and nulls Edmund Dengler <edmundd@eSentire.com>
Re: Type conversions and nulls Tom Lane <tgl@sss.pgh.pa.us>
Edmund Dengler  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
Дата:
От: Daniel Fitzgerald
Дата:
FAQ