Convert a Text to an Array - PostgreSQL

Question

im learning PostgreSQL and i encountered a little Problem.

I have a text like this:

'{1,1}'

and want to create an Array that holds my two values, so that i can access them. How do i do that ? I tried

SELECT string_to_array('{1,1}', '{', '}', ',');

But that does not seem to work.

user330315 · Accepted Answer · 2017-11-17 21:08:14Z

31

'{1,1}' can be casted to an array directly:

select '{1,1}'::int[]

answered Nov 17, 2017 at 21:08

user330315

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

2 Comments

Thank you ! But how can i access the values now ?