]> git.ipfire.org Git - thirdparty/postgresql.git/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)
commit5efa4a3e7008638732d14ffd7613f53823a75367
treed6181fc81ac2bddc482b7ac87e005d28a19550bf
parent465f4dddae6bfe882f95e9e04633c7c496826ac2
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