pgsql: Doc: clarify behavior of standard aggregates for null inputs. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Doc: clarify behavior of standard aggregates for null inputs.
Date
Msg-id E1i2iDp-0005sV-W2@gemulon.postgresql.org
Whole thread Raw
List 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
------
REL9_4_STABLE

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

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


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Add missing newline in help output.
Next
From: Tom Lane
Date:
Subject: pgsql: Doc: clarify behavior of standard aggregates for null inputs.