Skip site navigation (1) Skip section navigation (2)

Re: When is a record NULL?

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 (view raw or flat)
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

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2009-07-24 13:37:14
Subject: Re: join removal
Previous:From: Tom LaneDate: 2009-07-24 13:33:20
Subject: Re: join regression failure on cygwin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group