PostgreSQL: Does jsonb sort Objects in array?

Question

Example: [{3},{1},{2}]. Does it sort it? [{1},{2}, {3}]

I was confused because of this answer? https://stackoverflow.com/a/49833552/15502607

JSON maintains the order in which elements are inserted, while JSONB maintains the "sorted" order.

[{3},{1},{2}] is an invalid JSON value to begin with.

user330315
– user330315

2022-03-03 13:46:07 +00:00
Commented Mar 3, 2022 at 13:46 — user330315
– user330315, Commented Mar 3, 2022 at 13:46
example........

Itgelt Gankhulug
– Itgelt Gankhulug

2022-03-03 13:52:18 +00:00
Commented Mar 3, 2022 at 13:52 — Itgelt Gankhulug
– Itgelt Gankhulug, Commented Mar 3, 2022 at 13:52

ruohola · Accepted Answer · 2022-03-08 11:32:47Z

6

No, the point in the answer was about the order of the keys in a JSONB object. JSONB arrays maintain the order of their elements in the insertion order.

edited Mar 8, 2022 at 11:32

answered Mar 3, 2022 at 13:19

ruohola

24.8k7 gold badges76 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL: Does jsonb sort Objects in array?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related