Horton

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

Itagaki Takahiro <itagaki.takahiro@gmail.com>

View thread
From: Itagaki Takahiro <itagaki.takahiro@gmail.com>
To: Pavel Stehule <pavel.stehule@gmail.com>, Merlin Moncure <mmoncure@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-12-17T17:11:45Z
Lists: pgsql-hackers 
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?

-- 
Itagaki Takahiro