How to split an array into columns - Mailing list pgsql-general

From a
Subject How to split an array into columns
Date
Msg-id tencent_457E571D2754843359EF7ABA@qq.com
Whole thread Raw
Responses Re: How to split an array into columns
Re: How to split an array into columns
List pgsql-general
Say if I have an float8 array:

id| data
--|---------------
a | {1,2}
b | {2,4}

If I could using query to make it looks like this:

id| data[1] | data[2]
--|----------|-----------
a |      1      |     2
b |      2      |     4

Since I would have around 200,000 rows, I would prefer it having enough capacity to carry out the calculation such as sum().

Thank you so much!

pgsql-general by date:

Previous
From: Durumdara
Date:
Subject: Re: Hungarian collation in English Windows server
Next
From: Thomas Kellerer
Date:
Subject: Re: How to split an array into columns