On Tue, Aug 15, 2023 at 5:58 PM jian he <jian.universal...@gmail.com> wrote: > Hi. > in v11, json_query: > + The returned <replaceable>data_type</replaceable> has the > same semantics > + as for constructor functions like > <function>json_objectagg</function>; > + the default returned type is <type>text</type>. > + The <literal>ON EMPTY</literal> clause specifies the behavior if the > + <replaceable>path_expression</replaceable> yields no value at all; > the > + default when <literal>ON ERROR</literal> is not specified is > to return a > + null value. > > the default returned type is jsonb?
You are correct. > Also in above quoted second last > line should be <literal>ON EMPTY</literal> ? Correct too. > Other than that, the doc looks good. Thanks for the review. I will post a new version after finishing working on a few other improvements I am working on. -- Thanks, Amit Langote EDB: http://www.enterprisedb.com