Postgres text array to hstore

Question

I have an array of even length, with comma delimited values (not necessarily homogeneous):

'{"a", 10000, "b", 20000}'

I would like to parse this postgres array into an hstore column, associating each odd entry (index 1,3,...) as a key, and each even entry (index 2,4,...) as value. Is this possible?

Hstore supports directly construction from a text[] based on documentation. Did you try just hstore(array)? — Sami Kuhmonen
– Sami Kuhmonen, Commented Jan 24, 2018 at 5:56
hstore('{"a", 10000, "b", 20000}'::text[]) works just fine — user330315
– user330315, Commented Jan 24, 2018 at 7:46
Thanks all - my bad. If you lodge this as answer, I will tag it as correct answer. — MartinT
– MartinT, Commented Jan 30, 2018 at 0:24

mm49307 · Accepted Answer · 2020-10-19 00:14:57Z

2

As Sami mentioned, just use:

SELECT hstore('{"a", 10000, "b", 20000}'::text[]);

Output:

           hstore
----------------------------
 "a"=>"10000", "b"=>"20000"
(1 row)

answered Oct 19, 2020 at 0:14

mm49307

2,7572 gold badges21 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Postgres text array to hstore

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related