Re: remaining sql/json patches - Mailing list pgsql-hackers

From jian he
Subject Re: remaining sql/json patches
Date
Msg-id CACJufxGW+L+FSDgpuYdM-YQb0u+EpESYGtv_xmK1emGDPMvxQw@mail.gmail.com
Whole thread Raw
In response to Re: remaining sql/json patches  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: remaining sql/json patches
List pgsql-hackers
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?  Also in above quoted second last
line should be <literal>ON EMPTY</literal> ?
Other than that, the doc looks good.



pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: New WAL record to detect the checkpoint redo location
Next
From: Muneeb Anwar
Date:
Subject: Generating memory trace from Postgres backend process