pgsql: Doc: clarify behavior of standard aggregates for null inputs.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Doc: clarify behavior of standard aggregates for null inputs.
Дата
Msg-id E1i2iDp-0005sQ-Vo@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Doc: clarify behavior of standard aggregates for null inputs.

Section 4.2.7 says that unless otherwise specified, built-in
aggregates ignore rows in which any input is null.  This is
not true of the JSON aggregates, but it wasn't documented.
Fix that.

Of the other entries in table 9.55, some were explicit about
ignoring nulls, and some weren't; for consistency and
self-contained-ness, make them all say it explicitly.

Per bug #15884 from Tim Möhlmann.  Back-patch to all supported
branches.

Discussion: https://postgr.es/m/15884-c32d848f787fcae3@postgresql.org

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/f2cf22a59a49ddbe93dd231992d537f822d1b3c1

Modified Files
--------------
doc/src/sgml/func.sgml | 26 +++++++++++++++-----------
1 file changed, 15 insertions(+), 11 deletions(-)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Add missing newline in help output.
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Doc: clarify behavior of standard aggregates for null inputs.