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
> 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
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2009-07-24 13:37:14|
|Subject: Re: join removal|
|Previous:||From: Tom Lane||Date: 2009-07-24 13:33:20|
|Subject: Re: join regression failure on cygwin |