Re: pg ANY/SOME ambiguity wrt sql standard? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg ANY/SOME ambiguity wrt sql standard?
Date
Msg-id 14367.1083426320@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg ANY/SOME ambiguity wrt sql standard?  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: pg ANY/SOME ambiguity wrt sql standard?  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
Fabien COELHO <coelho@cri.ensmp.fr> writes:
> The standard "EVERY" is fine for postgres, the issue is only with
> ANY/SOME.
> Do you think that bool_and should be proposed anyway for homogeneity
> with bool_or?

I think EVERY is actively misleading, because it does *not* imply that
every input is TRUE.  The spec says these aggregates should ignore
nulls, and so a true result only implies that there were no FALSE
inputs.

OTOH one could argue that the ignore-nulls behavior makes this not a
true analog of AND, either ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Plan for feature freeze?
Next
From: Andrew Dunstan
Date:
Subject: Re: Plan for feature freeze?