Re: null != null ???

Поиск
Список
Период
Сортировка
От Brett W. McCoy
Тема Re: null != null ???
Дата
Msg-id Pine.LNX.4.30.0110261434180.2640-100000@chapelperilous.net
обсуждение исходный текст
Ответ на null != null ???  (Fran Fabrizio <ffabrizio@mmrd.com>)
Список pgsql-general
On Fri, 26 Oct 2001, Fran Fabrizio wrote:

> I have a situation where the left and right side of a where clause both
> evaluate to null independently, but when compared to
> each other, they don't equate.  Observe:

It seems to me that a null value cannot be compared to a null value
because NULL means 'no value' -- it would be like comparing two undefined
variables in Perl (undef) or two NULL pointers in C.  It will never be
true because you can't equate nothing to nothing.

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
God created a few perfect heads.  The rest he covered with hair.


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Triggers
Следующее
От: "Roderick A. Anderson"
Дата:
Сообщение: Re: DBD::Pg