Re: IN does not negate, exists does - Mailing list pgsql-bugs

O kyrios Tom Lane egrapse stis Feb 5, 2004 :

> Achilleus Mantzios <achill@matrix.gatewaynet.com> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

--
-Achilleus