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.html
Sent 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 по дате отправления:

Предыдущее
От: bricklen
Дата:
Сообщение: Re: Selecting consecutive dates as integers in yyyymmdd format
Следующее
От: Kumar Babu P G
Дата:
Сообщение: Postgres behavior - Conditional statements