Re: How to unnest an array with element indexes
| От | Pavel Stehule |
|---|---|
| Тема | Re: How to unnest an array with element indexes |
| Дата | |
| Msg-id | CAFj8pRBB90SYpxWY-sLxciODHD-NoPV=uRJch-qmNFxcSLi+2w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to unnest an array with element indexes (AlexK <alkuzo@gmail.com>) |
| Список | pgsql-sql |
2014-02-19 21:55 GMT+01:00 AlexK <alkuzo@gmail.com>:
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.
I cannot to say, what will be in next years - but it is less probable -- plans for parallelism are related for SQL executor internals - like parallel sort - or parallel hashing.
we have no plans do plpgsql parallel - now works well - and it is relative simple to maintain it.
Regards
Pavel
--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-unnest-an-array-with-element-indexes-tp5792770p5792787.htmlSent from the PostgreSQL - sql mailing list archive at Nabble.com.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
В списке pgsql-sql по дате отправления: