]> granicus.if.org Git - postgresql/commit
Doc: clarify behavior of standard aggregates for null inputs.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 27 Aug 2019 20:37:22 +0000 (16:37 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 27 Aug 2019 20:37:22 +0000 (16:37 -0400)
commitf2cf22a59a49ddbe93dd231992d537f822d1b3c1
tree812fac66f64aa76c29792f7966264be1b075e1d2
parent771e127013e844c262a40615ed94f7ac3285454c
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
doc/src/sgml/func.sgml