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.