Re: PL/pgSQL - Help or advice please on using unbound cursors

Поиск
Список
Период
Сортировка
От Andrew Hastie
Тема Re: PL/pgSQL - Help or advice please on using unbound cursors
Дата
Msg-id 500FF61C.4000608@ahastie.net
обсуждение исходный текст
Ответ на Re: PL/pgSQL - Help or advice please on using unbound cursors  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Yep, that fixed it. Many thanks for the pointer.

 From a performance point of view, I did look at using MOVE rather than
FETCH before I call UPDATE as I don't actually need to read the data
before applying the update. However in this situation, the ROW_COUNT is
always zero and can't be used which I suspect is reasonable.

Anyway, thanks for the help.

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

Предыдущее
От: leo xu
Дата:
Сообщение: how to calculate or know seq_scan scan how many blocks every time
Следующее
От: BJ Freeman
Дата:
Сообщение: upgrade causes psql to not work