Re: pg ANY/SOME ambiguity wrt sql standard?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg ANY/SOME ambiguity wrt sql standard?
Дата
Msg-id 14367.1083426320@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg ANY/SOME ambiguity wrt sql standard?  (Fabien COELHO <coelho@cri.ensmp.fr>)
Ответы Re: pg ANY/SOME ambiguity wrt sql standard?
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Plan for feature freeze?
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Plan for feature freeze?