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