Postgres Pro
Downloads
Home   >   mailing lists

Re: <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected
Date
Msg-id 649609.10373.qm@web31806.mail.mud.yahoo.com
Whole thread Raw
In response to Re: <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected  ("John D. Burger" <john@mitre.org>)
List pgsql-general
Tree view 
--- "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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected
Next
From: Vivek Khera
Date:
Subject: Re: time penalties on triggers?