Merlin Moncure <[email protected]> writes:
> On Fri, Dec 17, 2010 at 12:15 PM, Tom Lane <[email protected]> wrote:
>> [ scratches head... ] I don't follow what you envision this doing,
>> exactly?
> It's like _pg_expandarray but alterted support multiple dimensions:
> select * from unnest_dims(array[['a','b'],['c','d']]) returns
> [1,1], 'a'
> [1,2], 'b'
> [2,1], 'c'
> [2,2], 'd'
Oh, so that's an *output* not an input. And IIUC what you are returning
is the subscripts associated with the current element, not the array's
dimensions. Seems like it should go beside the normal target variable
then, not at the end.
FOREACH variable_for_value [, variable_for_subscripts ] IN ARRAY ...
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
