Home > mailing lists

Cast json array to postgres array and preserve order of elements - Mailing list pgsql-hackers

From	otar shavadze
Subject	Cast json array to postgres array and preserve order of elements
Date	May 10, 2020 15:21:35
Msg-id	CAG-jOyDBeXpiuztbB8RWnK6W5uEx1s_SJQ=wgu7c1AqAd33Fjg@mail.gmail.com Whole thread Raw
Responses	Re: Cast json array to postgres array and preserve order of elements
List	pgsql-hackers

When I want t to convert json array into postgres array, I do:

with t(j) as(
select '{"my_arr":[3,1,2]}'::json
)
SELECT ARRAY(SELECT json_array_elements_text(j->'my_arr')) from t

It works like a charm and I never noticed any problem, but I'm asking here just to make sure, order of elements will be preserved always?

Is that guaranteed in above example, or not?

Thanks.

From: Michael Paquier
Date: 10 May 2020, 05:00:36
Subject: Re: Should smgrdounlink() be removed?

From: Tomas Vondra
Date: 10 May 2020, 15:25:23
Subject: Re: [PATCH] Incremental sort (was: PoC: Partial sort)