RE: comparing rows

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
Serviceand other goodies at http://donb.photo.net.