Re: <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected
Дата
Msg-id 21915.1192042680@sss.pgh.pa.us
обсуждение исходный текст
Ответ на <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected  (Richard Broersma Jr <rabroersma@yahoo.com>)
Список pgsql-general
Дерево обсуждения 
Richard Broersma Jr <rabroersma@yahoo.com> writes:
> Can anyone explain why <> ANY() behaves that way it does?

Aside from the responses already given, I'm wondering whether you have
any NULL entries in Children.gender.  NULL rows within a NOT IN
subselect tend to produce confusing results ...

            regards, tom lane

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