At 10:15 AM 8/3/00 +0200, Magnus Hagander wrote:

>Isn't it just plain *wrong* to state that null = null? After all, NULL is
>unknown, and is not equal to anything, no?

According to the standard, yes, it is wrong.  

>Perhaps it would be more correct for postgresql to provide an option for
>"non-ANSI null handling" as well? And leaving ANSI compliant handling as the
>default?

I would think so.  



- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.

pgsql-hackers by date

Next:	From: Thomas Lockhart	Date: 2000-08-03 13:44:22
	Subject: Re: comparing rows
Previous:	From: Magnus Hagander	Date: 2000-08-03 08:15:20
	Subject: RE: comparing rows