Re: [HACKERS] Proposal: revert behavior of IS NULL on row types

[Andrew Gierth]

>>>>> "David" == David G Johnston <david.g.johns...@gmail.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)


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers