| From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: IN does not negate, exists does |
| Date: | 2004-02-06 08:13:25 |
| Message-ID: | Pine.LNX.4.44.0402061012410.19827-100000@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
O kyrios Tom Lane egrapse stis Feb 5, 2004 :
> Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
-Achilleus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-02-06 13:32:41 | Re: BUG #1073: JDBC "time with time zone" |
| Previous Message | elein | 2004-02-05 20:46:21 | [Resend: Domains and function] |