> 2010/9/28 Itagaki Takahiro <[email protected]>: >> On Tue, Sep 28, 2010 at 3:24 PM, Pavel Stehule <[email protected]> >> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
