Horton

Re: proposal: FOREACH-IN-ARRAY (probably for 9.2?)

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Robert Haas <robertmhaas@gmail.com>
Date: 2010-12-17T17:15:10Z
Lists: pgsql-hackers 
Merlin Moncure <mmoncure@gmail.com> writes:
> another way:

> FOREACH scalar IN ARRAY arr_exp DIMS in dim_var

> dim_var being int[], or possibly text, of length #dimensions, giving
> per dimesion index.

[ scratches head... ]  I don't follow what you envision this doing,
exactly?

I'm not thrilled with that specific syntax because it'd require making
DIMS a reserved word, but right at the moment I'm more concerned about
what semantics you have in mind.

			regards, tom lane