Re: final patch - plpgsql: for-in-array

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: final patch - plpgsql: for-in-array
Дата
Msg-id 5781.1290108283@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: final patch - plpgsql: for-in-array  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: final patch - plpgsql: for-in-array  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> this note was a different -only  a few people use FOR IN SELECT UNNEST
> for iteration over array. So from Robert's question (what is important
> for current code?) perspective the more significant is access to
> individual fields via subscripts. For example:

> for i in 1..10000 loop
>   s := s + A[i];
> end loop

> is slow, when high limit of array is some bigger number > 1000.

True, but inventing new FOR syntax isn't going to help people who are
used to doing that.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: describe objects, as in pg_depend
Следующее
От: Tom Lane
Дата:
Сообщение: Re: final patch - plpgsql: for-in-array