Re: IN does not negate, exists does

Поиск
Список
Период
Сортировка
От Achilleus Mantzios
Тема Re: IN does not negate, exists does
Дата
Msg-id Pine.LNX.4.44.0402061012410.19827-100000@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Re: IN does not negate, exists does  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: IN does not negate, exists does
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: BUG #1073: JDBC "time with time zone"