Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

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

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit4f601b9

Browse files
committed
Doc: alphabetize aggregate function table
A few recent JSON aggregates have been added without much considerationto the existing order. Put these back in alphabetical order (with theexception of the JSONB variant of each JSON aggregate).Author: Wolfgang Walther <walther@technowledgy.de>Reviewed-by: Marlene Reiterer <marlene.reiterer.03@gmail.com>Discussion:https://postgr.es/m/6a7b910c-3feb-4006-b817-9b4759cb6bb6%40technowledgy.deBackpatch-through: 16, where these aggregates were added
1 parentf333662 commit4f601b9

File tree

1 file changed

+48
-48
lines changed

1 file changed

+48
-48
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 48 additions & 48 deletions
Original file line numberDiff line numberDiff line change
@@ -20327,6 +20327,54 @@ SELECT NULLIF(value, '(none)') ...
2032720327
<entry>No</entry>
2032820328
</row>
2032920329

20330+
<row>
20331+
<entry role="func_table_entry"><para role="func_signature">
20332+
<indexterm>
20333+
<primary>json_agg_strict</primary>
20334+
</indexterm>
20335+
<function>json_agg_strict</function> ( <type>anyelement</type> )
20336+
<returnvalue>json</returnvalue>
20337+
</para>
20338+
<para role="func_signature">
20339+
<indexterm>
20340+
<primary>jsonb_agg_strict</primary>
20341+
</indexterm>
20342+
<function>jsonb_agg_strict</function> ( <type>anyelement</type> )
20343+
<returnvalue>jsonb</returnvalue>
20344+
</para>
20345+
<para>
20346+
Collects all the input values, skipping nulls, into a JSON array.
20347+
Values are converted to JSON as per <function>to_json</function>
20348+
or <function>to_jsonb</function>.
20349+
</para></entry>
20350+
<entry>No</entry>
20351+
</row>
20352+
20353+
<row>
20354+
<entry role="func_table_entry"><para role="func_signature">
20355+
<indexterm><primary>json_arrayagg</primary></indexterm>
20356+
<function>json_arrayagg</function> (
20357+
<optional> <replaceable>value_expression</replaceable> </optional>
20358+
<optional> <literal>ORDER BY</literal> <replaceable>sort_expression</replaceable> </optional>
20359+
<optional> { <literal>NULL</literal> | <literal>ABSENT</literal> } <literal>ON NULL</literal> </optional>
20360+
<optional> <literal>RETURNING</literal> <replaceable>data_type</replaceable> <optional> <literal>FORMAT JSON</literal> <optional> <literal>ENCODING UTF8</literal> </optional> </optional> </optional>)
20361+
</para>
20362+
<para>
20363+
Behaves in the same way as <function>json_array</function>
20364+
but as an aggregate function so it only takes one
20365+
<replaceable>value_expression</replaceable> parameter.
20366+
If <literal>ABSENT ON NULL</literal> is specified, any NULL
20367+
values are omitted.
20368+
If <literal>ORDER BY</literal> is specified, the elements will
20369+
appear in the array in that order rather than in the input order.
20370+
</para>
20371+
<para>
20372+
<literal>SELECT json_arrayagg(v) FROM (VALUES(2),(1)) t(v)</literal>
20373+
<returnvalue>[2, 1]</returnvalue>
20374+
</para></entry>
20375+
<entry>No</entry>
20376+
</row>
20377+
2033020378
<row>
2033120379
<entry role="func_table_entry"><para role="func_signature">
2033220380
<indexterm><primary>json_objectagg</primary></indexterm>
@@ -20435,31 +20483,6 @@ SELECT NULLIF(value, '(none)') ...
2043520483
<entry>No</entry>
2043620484
</row>
2043720485

20438-
<row>
20439-
<entry role="func_table_entry"><para role="func_signature">
20440-
<indexterm><primary>json_arrayagg</primary></indexterm>
20441-
<function>json_arrayagg</function> (
20442-
<optional> <replaceable>value_expression</replaceable> </optional>
20443-
<optional> <literal>ORDER BY</literal> <replaceable>sort_expression</replaceable> </optional>
20444-
<optional> { <literal>NULL</literal> | <literal>ABSENT</literal> } <literal>ON NULL</literal> </optional>
20445-
<optional> <literal>RETURNING</literal> <replaceable>data_type</replaceable> <optional> <literal>FORMAT JSON</literal> <optional> <literal>ENCODING UTF8</literal> </optional> </optional> </optional>)
20446-
</para>
20447-
<para>
20448-
Behaves in the same way as <function>json_array</function>
20449-
but as an aggregate function so it only takes one
20450-
<replaceable>value_expression</replaceable> parameter.
20451-
If <literal>ABSENT ON NULL</literal> is specified, any NULL
20452-
values are omitted.
20453-
If <literal>ORDER BY</literal> is specified, the elements will
20454-
appear in the array in that order rather than in the input order.
20455-
</para>
20456-
<para>
20457-
<literal>SELECT json_arrayagg(v) FROM (VALUES(2),(1)) t(v)</literal>
20458-
<returnvalue>[2, 1]</returnvalue>
20459-
</para></entry>
20460-
<entry>No</entry>
20461-
</row>
20462-
2046320486
<row>
2046420487
<entry role="func_table_entry"><para role="func_signature">
2046520488
<indexterm>
@@ -20568,29 +20591,6 @@ SELECT NULLIF(value, '(none)') ...
2056820591
<entry>No</entry>
2056920592
</row>
2057020593

20571-
<row>
20572-
<entry role="func_table_entry"><para role="func_signature">
20573-
<indexterm>
20574-
<primary>json_agg_strict</primary>
20575-
</indexterm>
20576-
<function>json_agg_strict</function> ( <type>anyelement</type> )
20577-
<returnvalue>json</returnvalue>
20578-
</para>
20579-
<para role="func_signature">
20580-
<indexterm>
20581-
<primary>jsonb_agg_strict</primary>
20582-
</indexterm>
20583-
<function>jsonb_agg_strict</function> ( <type>anyelement</type> )
20584-
<returnvalue>jsonb</returnvalue>
20585-
</para>
20586-
<para>
20587-
Collects all the input values, skipping nulls, into a JSON array.
20588-
Values are converted to JSON as per <function>to_json</function>
20589-
or <function>to_jsonb</function>.
20590-
</para></entry>
20591-
<entry>No</entry>
20592-
</row>
20593-
2059420594
<row>
2059520595
<entry role="func_table_entry"><para role="func_signature">
2059620596
<indexterm>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp