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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
