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

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

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Robert Haas <robertmhaas@gmail.com>
Date: 2010-12-17T15:47:38Z
Lists: pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> I am resending a redesigned proposal about special plpgsql statement
> that support iteration over an array.

OK ...

> == Iteration over multidimensional arrays ==
> Its designed to reduce one dimension from source array. It can remove
> a slicing and simplify code:

This seems like a really bad, confusing idea.  I think it should throw
a type-mismatch error in this case.  If there is any use-case for such a
thing, which I'm quite unconvinced of, it ought to use a separate syntax
rather than overloading the element-by-element syntax.

			regards, tom lane