RE: comparing rows - Mailing list pgsql-hackers

From Don Baccus
Subject RE: comparing rows
Date
Msg-id 3.0.1.32.20000803062210.014e04f0@mail.pacifier.com
Whole thread Raw
In response to comparing rows  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
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.
 


pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: comparing rows
Next
From: Magnus Hagander
Date:
Subject: RE: comparing rows