generic way to retrieve array as rowset

[SunWuKung <Balazs.Klein@xxxxxxxxxx>]

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