Re: remaining sql/json patches

On Tue, Aug 15, 2023 at 5:58 PM jian he <jian(dot)universality(at)gmail(dot)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