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

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема Re: <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected
Дата
Msg-id 649609.10373.qm@web31806.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected  ("John D. Burger" <john@mitre.org>)
Список pgsql-general
--- "John D. Burger" <john@mitre.org> wrote:
> I read this as: Find all parents such that none of their kids are
> girls and none of their kids are boys.  That is, ALL of their genders
> are <> 'girl', AND ALL of their genders are <> 'boy'.  Under the
> obvious assumptions about gender, the result is of course empty -
> except it's not clear to me what should happen for childless people ...

Thanks everyone that makes sense!

Regards,
Richard Broersma Jr.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: time penalties on triggers?