On Sat, 2010-10-09 at 23:28 +0000, Corin wrote:
> I'd consider this a bug as "NOT x IS NULL" is the same as "x IS NOT NULL".
That is false.
http://thoughts.j-davis.com/2009/08/02/what-is-the-deal-with-nulls/
"NOT x IS NULL is not the same as x IS NOT NULL — If x is ROW(1,NULL),
then the former will evaluate to TRUE, and the latter will evaluate to
FALSE. Enjoy."
=> select ROW(1, NULL) IS NOT NULL;
?column?
----------
f
(1 row)
=> select NOT ROW(1, NULL) IS NULL;
?column?
----------
t
(1 row)
Regards,
Jeff Davis