Re: When is a record NULL?

"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