Re: problem selecting rows with null value

Поиск
Список
Период
Сортировка
От Taral
Тема Re: problem selecting rows with null value
Дата
Msg-id 20030313015500.GA3608@taral.net
обсуждение исходный текст
Ответ на Re: problem selecting rows with null value  (Jord Tanner <jord@indygecko.com>)
Ответы Re: problem selecting rows with null value  (Larry Rosenman <ler@lerctr.org>)
Список pgsql-general
On Wed, Mar 12, 2003 at 04:55:31PM -0800, Jord Tanner wrote:
> Use 'IS NULL' or 'IS NOT NULL' like this:
>
>     select * from pleah where bar IS NULL;
>
> '=' does not work for null values.

I was pretty sure there was supposed to be an automatic rewrite for that
since "= NULL" is so common...

--
Taral <taral@taral.net>
This message is digitally signed. Please PGP encrypt mail to me.
"Most parents have better things to do with their time than take care of
their children." -- Me

Вложения

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

Предыдущее
От: Jord Tanner
Дата:
Сообщение: Re: problem selecting rows with null value
Следующее
От: Larry Rosenman
Дата:
Сообщение: Re: problem selecting rows with null value