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)
commitfe50481899e890d5d2587fbd4748b658667dc71a
treefbb87948277963d9616fba5ba87c7dbbe5f2091e
parenta5364a3df57845af2a2d40938347b555899a0502
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