Re: null != null ??? - Mailing list pgsql-general

From Brett W. McCoy
Subject Re: null != null ???
Date
Msg-id Pine.LNX.4.30.0110261434180.2640-100000@chapelperilous.net
Whole thread Raw
In response to null != null ???  (Fran Fabrizio <ffabrizio@mmrd.com>)
List 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 by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Triggers
Next
From: "Roderick A. Anderson"
Date:
Subject: Re: DBD::Pg