[GENERAL] generic way to retrieve array as rowset

[SunWuKung]

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend