Re: JSONB order? - Mailing list pgsql-general

From Christophe Pettus
Subject Re: JSONB order?
Date
Msg-id 85B65AB1-BD99-4F15-9B33-86F2B00EA106@thebuild.com
Whole thread Raw
In response to JSONB order?  (Tony Shelver <tshelver@gmail.com>)
List pgsql-general

> On Nov 5, 2020, at 07:34, Tony Shelver <tshelver@gmail.com> wrote:
> But...  seen above, the order gets mixed up.
>
> Any ideas?

JSON objects, like Python dicts, are not automatically ordered by key.  Once you move from the column space to the JSON
objectspace, you can't rely on the object keys being in a consistent order. 

You'll want to have a step when ingesting the JSON object into a report that lines up the key values appropriately with
theright presentation in the report. 
--
-- Christophe Pettus
   xof@thebuild.com




pgsql-general by date:

Previous
From: Tony Shelver
Date:
Subject: JSONB order?
Next
From: Magnus Hagander
Date:
Subject: Re: JSONB order?