Re: How to unnest an array with element indexes

Pavel,

This works for me, thank you!

Presumably foreach is guaranteed to iterate array elements in order: "The
elements are visited in storage order, regardless of the number of array
dimensions", quoted from this:

http://www.postgresql.org/docs/9.2/static/plpgsql-control-structures.html

Since parallelism is coming up, will this behavior stay as documented? My
arrays are as big as 20K-30K elements, maybe more.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-unnest-an-array-with-element-indexes-tp5792770p5792787.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.