Ambiguous statement about order - Mailing list pgsql-docs

From David G. Johnston
Subject Ambiguous statement about order
Date
Msg-id CAKFQuwY6MT-vzJb+kkE3EN0XYJY=NxyYvtwWARGuYQCDuRJWHg@mail.gmail.com
Whole thread Raw
In response to Ambiguous statement about order  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
On Thursday, September 14, 2023, PG Doc comments form <noreply@postgresql.org> wrote:
I observed that arrays inside JSONB preserved order of insertion. An
explicit line about whether the array order will be preserved or not would
be helpful.

We don’t take on responsibility for teaching people what json is.  Json arrays are slotted composite elements where the slots are numerically indexed.  That, by definition, makes their contents “ordered”.  The fact that object keys are unordered and that arrays can be object keys is immaterial to whether the contents of arrays are ordered.

David J.

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: Ambiguous statement about order
Next
From: Daniel Gustafsson
Date:
Subject: Re: file-fdw and force_null