Re: Proposal: revert behavior of IS NULL on row types

>>>>> "David" == David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> writes:

>> 1. x IS NULL is true if and only if x has the null value (isnull set).

David> ​I don't have a problem conforming to "ROW(NULL, NULL) IS NULL"
David> being true...​if you somehow get a hold of something in that
David> form, which your others points address.

This seems harmless, but I think it's not worth the pain.

I'm informed that for example on Oracle:

select case when foo_type(null, null) is null
then 'true' else 'false'
end from dual;

returns 'false'.

--
Andrew (irc:RhodiumToad)