Re: plpgsql and INSERT/UPDATE/DELETE RETURNING

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql and INSERT/UPDATE/DELETE RETURNING
Дата
Msg-id 26553.1155599769@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: plpgsql and INSERT/UPDATE/DELETE RETURNING  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-hackers
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> Aggregates sound interesting, though I'm not sure how useful they'd
> actually be. I think something like
>    FOR v_row IN (UPDATE ... RETURNING ...)
> would be a lot more useful (if it's not already in the patch).

It's not.  I thought about it for a bit but there are some nasty gotchas
if the planner decides it needs to rescan the subquery multiple times.
I'd say that's something to leave for 8.3 ...
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: domains code query
Следующее
От: andrew@dunslane.net
Дата:
Сообщение: Re: domains code query