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

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>
To: Itagaki Takahiro <itagaki.takahiro@gmail.com>
Cc: Merlin Moncure <mmoncure@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-12-17T17:15:57Z
Lists: pgsql-hackers
2010/12/17 Itagaki Takahiro <itagaki.takahiro@gmail.com>:
> On Sat, Dec 18, 2010 at 02:03, Merlin Moncure <mmoncure@gmail.com> wrote:
>>>        FOREACH scalar-variable IN ARRAY array-expression
>>>        FOR_EACH scalar-variable IN ARRAY array-expression
>>>        FOR_SLICE array-variable [DEPTH n] IN ARRAY array-expression
>>>        FOREACH scalar-variable IN ARRAY array-expression
>>>        FOREACH array-variable SLICE n IN ARRAY array-expression
>> FOREACH scalar IN ARRAY arr_exp DIMS in dim_var
>
> It should be not a main subject, but I remember there was a discussion
> that "IN ARRAY array-expression" looks redundant for a literal array:
>
>  IN ARRAY ARRAY[1, 3, 5]
>
> Are there any improvement for the issue?

yes. It know it. The reason for this is bigger space for possible
future features related to FOREACH loop.

Regards

Pavel

>
> --
> Itagaki Takahiro
>