how to select value in array with index in postgresql?

Question

id	list
1	{759-10,1147-7,931-10}
2	{719-10,117-2}

expected

id	list1	list2
1	759-10	931-10
2	719-10	117-2

What are you trying to do ? What is the logic behind this expected result ? What have you tried ? — AymDev
– AymDev, Commented Jun 11, 2021 at 10:53

Gordon Linoff · Accepted Answer · 2021-06-11 10:53:49Z

1

If you just want the first and last elements, use array operations:

select id, list[1], list[cardinality(list)]
from t;

Here is a db<>fiddle.

answered Jun 11, 2021 at 10:53

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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