diff options
| -rw-r--r-- | doc/src/sgml/func.sgml | 26 |
1 files changed, 15 insertions, 11 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 672bf5cb708..f81b163bf8b 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -13513,7 +13513,7 @@ NULL baz</literallayout>(3 rows)</entry> <entry>No</entry> <entry>input arrays concatenated into array of one higher dimension (inputs must all have same dimensionality, - and cannot be empty or NULL)</entry> + and cannot be empty or null)</entry> </row> <row> @@ -13537,7 +13537,7 @@ NULL baz</literallayout>(3 rows)</entry> otherwise the same as the argument data type </entry> <entry>Yes</entry> - <entry>the average (arithmetic mean) of all input values</entry> + <entry>the average (arithmetic mean) of all non-null input values</entry> </row> <row> @@ -13665,7 +13665,7 @@ NULL baz</literallayout>(3 rows)</entry> <type>json</type> </entry> <entry>No</entry> - <entry>aggregates values as a JSON array</entry> + <entry>aggregates values, including nulls, as a JSON array</entry> </row> <row> @@ -13682,7 +13682,7 @@ NULL baz</literallayout>(3 rows)</entry> <type>jsonb</type> </entry> <entry>No</entry> - <entry>aggregates values as a JSON array</entry> + <entry>aggregates values, including nulls, as a JSON array</entry> </row> <row> @@ -13699,7 +13699,8 @@ NULL baz</literallayout>(3 rows)</entry> <type>json</type> </entry> <entry>No</entry> - <entry>aggregates name/value pairs as a JSON object</entry> + <entry>aggregates name/value pairs as a JSON object; values can be + null, but not names</entry> </row> <row> @@ -13716,7 +13717,8 @@ NULL baz</literallayout>(3 rows)</entry> <type>jsonb</type> </entry> <entry>No</entry> - <entry>aggregates name/value pairs as a JSON object</entry> + <entry>aggregates name/value pairs as a JSON object; values can be + null, but not names</entry> </row> <row> @@ -13732,7 +13734,7 @@ NULL baz</literallayout>(3 rows)</entry> <entry>Yes</entry> <entry> maximum value of <replaceable - class="parameter">expression</replaceable> across all input + class="parameter">expression</replaceable> across all non-null input values </entry> </row> @@ -13750,7 +13752,7 @@ NULL baz</literallayout>(3 rows)</entry> <entry>Yes</entry> <entry> minimum value of <replaceable - class="parameter">expression</replaceable> across all input + class="parameter">expression</replaceable> across all non-null input values </entry> </row> @@ -13772,7 +13774,7 @@ NULL baz</literallayout>(3 rows)</entry> same as argument types </entry> <entry>No</entry> - <entry>input values concatenated into a string, separated by delimiter</entry> + <entry>non-null input values concatenated into a string, separated by delimiter</entry> </row> <row> @@ -13795,7 +13797,8 @@ NULL baz</literallayout>(3 rows)</entry> argument data type </entry> <entry>Yes</entry> - <entry>sum of <replaceable class="parameter">expression</replaceable> across all input values</entry> + <entry>sum of <replaceable class="parameter">expression</replaceable> + across all non-null input values</entry> </row> <row> @@ -13812,7 +13815,8 @@ NULL baz</literallayout>(3 rows)</entry> <type>xml</type> </entry> <entry>No</entry> - <entry>concatenation of XML values (see also <xref linkend="functions-xml-xmlagg"/>)</entry> + <entry>concatenation of non-null XML values + (see also <xref linkend="functions-xml-xmlagg"/>)</entry> </row> </tbody> </tgroup> |