On 04/24/2016 06:02 PM, Sehrope Sarkuni wrote:
AFAIK, there's also no guarantee on the specific order of the
resulting properties in the text representation either. I would
suppose it's fixed for a given jsonb value within a database major
version but across major versions it could change (if the underlying
The order is fixed and very unlikely to change, as it was chosen quite
deliberately to help ensure efficient processing. Any change in on-disk
representation of data types is something we work very hard to avoid, as
it makes it impossible to run pg_upgrade.
It's true that the storage order of keys is not terribly intuitive.
Note that the json type, unlike jsonb, preserves exactly the white space
and key order of its input. In fact, the input is exactly what it stores.
Sent via pgsql-hackers mailing list (firstname.lastname@example.org)
To make changes to your subscription: