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@pacifier.com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.

Thu, 03 Aug 2000 06:22:10 -0700
Don Baccus <dhogaza@pacifier.com>
RE: comparing rows 