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 >