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
signature.asc
Description: Digital signature