On Jul 23, 2009, at 4:08 PM, Tom Lane wrote:
> 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.
>
> Yeah, it's a bit dubious, but that's what they said.
And yet they're DISTINCT FROM each other if either or both contain
NULLs and some other values? It seems to me that, to be consistent, it
should be:
select ROW(1, NULL) IS DISTINCT FROM ROW(2, NULL); ?column? ---------- f
No?
Best,
David