| From: | Joshua Tolley <eggyknap(at)gmail(dot)com> |
|---|---|
| To: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
| Cc: | Greg Stark <gsstark(at)mit(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: When is a record NULL? |
| Date: | 2009-07-24 13:36:46 |
| Message-ID: | 20090724133646.GB6606@eddie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Jul 23, 2009 at 06:46:25PM -0700, David E. Wheeler wrote:
> Yes, but given that the standard says that `ROW(1, NULL)` is NULL, then I
> would expect it to be NOT DISTINCT from `ROW(2, NULL)`.
Wait, didn't we decide upthread that the standard said ROW(1, NULL) isn't
NULL?
(From Tom):
> This is per SQL standard. IS NULL is true if *all* the record's
> fields are null; IS NOT NULL is true if *none* of them are.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2009-07-24 13:37:14 | Re: join removal |
| Previous Message | Tom Lane | 2009-07-24 13:33:20 | Re: join regression failure on cygwin |