Horton

Re: REVIEW: WIP: plpgsql - foreach in

Itagaki Takahiro <itagaki.takahiro@gmail.com>

View thread
From: Itagaki Takahiro <itagaki.takahiro@gmail.com>
To: Stephen Frost <sfrost@snowman.net>
Cc: Robert Haas <robertmhaas@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2011-01-26T09:13:51Z
Lists: pgsql-hackers 
On Mon, Jan 24, 2011 at 13:05, Stephen Frost <sfrost@snowman.net> wrote:
> FOR var in ARRAY array_expression ...
>
> I like that a lot more than inventing a new top-level keyword,

AFAIR, the syntax is not good at an array literal.
  FOR var IN ARRAY ARRAY[1,2,5] LOOP ...
And it was the only drawback compared with FOREACH var IN expr.

-- 
Itagaki Takahiro