> 2010/9/28 Itagaki Takahiro <itagaki.takah...@gmail.com>: >> On Tue, Sep 28, 2010 at 3:24 PM, Pavel Stehule <pavel.steh...@gmail.com> >> wrote: >>> I looked on some constructs that helps with iteration over array in >>> plpgsql. I propose a following syntax: >>> >>> FOR var IN [array variable | array expression] >> >> What is the benefits compared with >> FOR ... IN SELECT unnest(array) or generate_subscripts(array) ? >> > > the speed >
Not to mention that it's far more aesthetically pleasing, and makes the statement immediately understandable to people unfamiliar with the plpgsql idioms you describe. -- Regards, Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
