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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs