On 2024-12-09 Mo 11:16 AM, jian he wrote:
On Mon, Dec 9, 2024 at 9:27 PM Yan Chengpeng <chengpeng_...@outlook.com> wrote:
Sorry, I uploaded the wrong file. I uploaded a new patch with the modified
document. Please take a review. Thanks!
sorry. maybe i didn't mention it explicitly.
i mean something like:
diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml
index 54648c459c..d9b24e413e 100644
--- a/doc/src/sgml/json.sgml
+++ b/doc/src/sgml/json.sgml
@@ -584,12 +584,13 @@ SELECT jdoc->'guid', jdoc->'name' FROM api WHERE
jdoc @@ '$.tags[*] == "qui"';
The <literal>btree</literal> ordering for <type>jsonb</type>
datums is seldom
of great interest, but for completeness it is:
<synopsis>
-<replaceable>Object</replaceable> > <replaceable>Array</replaceable>
<replaceable>Boolean</replaceable> >
<replaceable>Number</replaceable> > <replaceable>String</replaceable>
<replaceable>Null</replaceable>
+<replaceable>Object</replaceable> > <replaceable>Array</replaceable>
<replaceable>Boolean</replaceable> >
<replaceable>Number</replaceable> > <replaceable>String</replaceable>
<replaceable>null</replaceable>
<replaceable>Object with n pairs</replaceable> > <replaceable>object
with n - 1 pairs</replaceable>
<replaceable>Array with n elements</replaceable> > <replaceable>array
with n - 1 elements</replaceable>
</synopsis>
+ with the exception that (for historical reasons) an empty array
sorts less than <replaceable>null</replaceable>.
Objects with equal numbers of pairs are compared in the order:
<synopsis>
<replaceable>key-1</replaceable>, <replaceable>value-1</replaceable>,
<replaceable>key-2</replaceable> ...
Pushed something along these lines. In master I also added a code
comment so nobody might be tempted to "fix" the anomaly.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
