BUG #2178: NOT IN command don't work

Поиск
Список
Период
Сортировка
От Daniel Afonso Heisler
Тема BUG #2178: NOT IN command don't work
Дата
Msg-id 20060117220028.2DB9DF0B01@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2178: NOT IN command don't work  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: BUG #2178: NOT IN command don't work  (Michael Fuhr <mike@fuhr.org>)
Re: BUG #2178: NOT IN command don't work  (Reece Hart <reece@harts.net>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2178
Logged by:          Daniel Afonso Heisler
Email address:      daniel@solis.coop.br
PostgreSQL version: 8.1.X
Operating system:   Linux
Description:        NOT IN command don't work
Details:

When i run the following query, postgreSQL return TRUE.
 # SELECT true WHERE 1 NOT IN (2,3);

But, when i run the next query, it don't return TRUE
 # SELECT true WHERE 1 NOT IN (2,NULL,3);

In theory, that is not correctly. The operator IN work with normally. See
the next example:

 # SELECT true WHERE 1 IN (1,2,NULL,3);

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

Предыдущее
От: "Giles Morant"
Дата:
Сообщение: BUG #2177: (minor:) pgsql: Trailing semicolon on \d treated as argument
Следующее
От: "stephanie"
Дата:
Сообщение: BUG #2179: psql can't show chinese