generic way to retrieve array as rowset - Mailing list pgsql-general

From SunWuKung
Subject generic way to retrieve array as rowset
Date
Msg-id MPG.1e248068a70a8302989682@news.postgresql.org
Whole thread Raw
Responses Re: generic way to retrieve array as rowset
Re: generic way to retrieve array as rowset
List pgsql-general
When storing data in an array, like this

id    array
1,     {1,2}
2,     {10,20}
3,     {100,200}

is there a generic way to retrieve them as arowset, like this

id    array_dimension1
1    1
1     2
2     10
2     20

By writing something like this:

Select id, explode(array) From foo Where id<3

(I know - store it as a table instead of an array, but beside that.)

Thanks.
Balázs

pgsql-general by date:

Previous
From: "xiapw"
Date:
Subject: who has some document about extending postgresql
Next
From: "A. Kretschmer"
Date:
Subject: Re: generic way to retrieve array as rowset