Re: When is a record NULL? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: When is a record NULL?
Date
Msg-id 15091.1248391357@sss.pgh.pa.us
Whole thread Raw
In response to Re: When is a record NULL?  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: When is a record NULL?
List pgsql-hackers
"David E. Wheeler" <david@kineticode.com> writes:
> And yet they're DISTINCT FROM each other if either or both contain  
> NULLs and some other values?

Well, that would depend on what the values were and in what columns...

> It seems to me that, to be consistent, it  
> should be:

>      select ROW(1, NULL) IS DISTINCT FROM ROW(2, NULL);
>      ?column?
>      ----------
>      f

Dunno how you can possibly come to that conclusion.  Those row
values are certainly distinct (according to both PG and the spec).
        regards, tom lane


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: When is a record NULL?
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: WIP: to_char, support for EEEE format