NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitfe50481

committed

Doc: clarify behavior of standard aggregates for null inputs.

Section 4.2.7 says that unless otherwise specified, built-inaggregates ignore rows in which any input is null. This isnot true of the JSON aggregates, but it wasn't documented.Fix that.Of the other entries in table 9.55, some were explicit aboutignoring nulls, and some weren't; for consistency andself-contained-ness, make them all say it explicitly.Per bug #15884 from Tim Möhlmann. Back-patch to all supportedbranches.Discussion:https://postgr.es/m/15884-c32d848f787fcae3@postgresql.org

1 parenta5364a3 commitfe50481Copy full SHA for fe50481

File tree

1 file changed

+11

-8

lines changed

doc/src/sgml
- func.sgml

1 file changed

+11

-8

lines changed

`‎doc/src/sgml/func.sgml`

Lines changed: 11 additions & 8 deletions

Original file line number	Diff line number	Diff line change
`@@ -12200,7 +12200,7 @@ NULL baz</literallayout>(3 rows)</entry>`
`12200`	`12200`	`<type>double precision</type> for a floating-point argument,`
`12201`	`12201`	`otherwise the same as the argument data type`
`12202`	`12202`	`</entry>`
`12203`		`- <entry>the average (arithmetic mean) of all input values</entry>`
	`12203`	`+ <entry>the average (arithmetic mean) of allnon-nullinput values</entry>`
`12204`	`12204`	`</row>`
`12205`	`12205`
`12206`	`12206`	`<row>`
`@@ -12320,7 +12320,7 @@ NULL baz</literallayout>(3 rows)</entry>`
`12320`	`12320`	`<entry>`
`12321`	`12321`	`<type>json</type>`
`12322`	`12322`	`</entry>`
`12323`		`- <entry>aggregates values as a JSON array</entry>`
	`12323`	`+ <entry>aggregates values, including nulls, as a JSON array</entry>`
`12324`	`12324`	`</row>`
`12325`	`12325`
`12326`	`12326`	`<row>`
`@@ -12336,7 +12336,8 @@ NULL baz</literallayout>(3 rows)</entry>`
`12336`	`12336`	`<entry>`
`12337`	`12337`	`<type>json</type>`
`12338`	`12338`	`</entry>`
`12339`		`- <entry>aggregates name/value pairs as a JSON object</entry>`
	`12339`	`+ <entry>aggregates name/value pairs as a JSON object; values can be`
	`12340`	`+ null, but not names</entry>`
`12340`	`12341`	`</row>`
`12341`	`12342`
`12342`	`12343`	`<row>`
`@@ -12350,7 +12351,7 @@ NULL baz</literallayout>(3 rows)</entry>`
`12350`	`12351`	`<entry>same as argument type</entry>`
`12351`	`12352`	`<entry>`
`12352`	`12353`	`maximum value of <replaceable`
`12353`		`- class="parameter">expression</replaceable> across all input`
	`12354`	`+ class="parameter">expression</replaceable> across allnon-nullinput`
`12354`	`12355`	`values`
`12355`	`12356`	`</entry>`
`12356`	`12357`	`</row>`
`@@ -12366,7 +12367,7 @@ NULL baz</literallayout>(3 rows)</entry>`
`12366`	`12367`	`<entry>same as argument type</entry>`
`12367`	`12368`	`<entry>`
`12368`	`12369`	`minimum value of <replaceable`
`12369`		`- class="parameter">expression</replaceable> across all input`
	`12370`	`+ class="parameter">expression</replaceable> across allnon-nullinput`
`12370`	`12371`	`values`
`12371`	`12372`	`</entry>`
`12372`	`12373`	`</row>`
`@@ -12387,7 +12388,7 @@ NULL baz</literallayout>(3 rows)</entry>`
`12387`	`12388`	`<entry>`
`12388`	`12389`	`same as argument types`
`12389`	`12390`	`</entry>`
`12390`		`- <entry>input values concatenated into a string, separated by delimiter</entry>`
	`12391`	`+ <entry>non-nullinput values concatenated into a string, separated by delimiter</entry>`
`12391`	`12392`	`</row>`
`12392`	`12393`
`12393`	`12394`	`<row>`
`@@ -12409,7 +12410,8 @@ NULL baz</literallayout>(3 rows)</entry>`
`12409`	`12410`	`<type>bigint</type> arguments, otherwise the same as the`
`12410`	`12411`	`argument data type`
`12411`	`12412`	`</entry>`
`12412`		`- <entry>sum of <replaceable class="parameter">expression</replaceable> across all input values</entry>`
	`12413`	`+ <entry>sum of <replaceable class="parameter">expression</replaceable>`
	`12414`	`+ across all non-null input values</entry>`
`12413`	`12415`	`</row>`
`12414`	`12416`
`12415`	`12417`	`<row>`
`@@ -12425,7 +12427,8 @@ NULL baz</literallayout>(3 rows)</entry>`
`12425`	`12427`	`<entry>`
`12426`	`12428`	`<type>xml</type>`
`12427`	`12429`	`</entry>`
`12428`		`- <entry>concatenation of XML values (see also <xref linkend="functions-xml-xmlagg">)</entry>`
	`12430`	`+ <entry>concatenation of non-null XML values`
	`12431`	`+ (see also <xref linkend="functions-xml-xmlagg">)</entry>`
`12429`	`12432`	`</row>`
`12430`	`12433`	`</tbody>`
`12431`	`12434`	`</tgroup>`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitfe50481

File tree

1 file changed

1 file changed

`‎doc/src/sgml/func.sgml`

0 commit comments