Re: "large" IN/NOT IN subqueries result in query returning wrong data - Mailing list pgsql-sql

Yes, yes, of course... There are nulls in my t1 table. And, of course,
NOT IN can return THREE possible values: not just TRUE or FALSE but also
NULL...

select distinct (moo.goo not in (null)) from moo;
--> null

select count(*) from moo where moo.goo not in ('gai', 'pan', null)
--> 0, no matter what the goo values are

Sorry...

Thanks!

George