O kyrios Tom Lane egrapse stis Feb 5, 2004 :
> Achilleus Mantzios <[EMAIL PROTECTED]> writes:
> > Whereas IN seems to not working ok when negated as shown below:
>
> If the sub-select returns any NULLs then this behavior is per SQL spec.
Thanx a lot!
>
> regards, tom lane
Achilleus Mantzios <[EMAIL PROTECTED]> writes:
> Whereas IN seems to not working ok when negated as shown below:
If the sub-select returns any NULLs then this behavior is per SQL spec.
regards, tom lane
---(end of broadcast)
EXISTS and IN seem to work ok for:
dynacom=# SELECT count(*) from parts p where p.id in (select md.partid
from machdefs md);
count
---
12656
(1 row)
dynacom=# SELECT count(*) from parts p where exists (select 1 from
machdefs md where md.partid = p.id);
count
---
12656
(1 row)
Wh
