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.
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных
