Re: storing intermediate results in recursive plpgsql functions

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: storing intermediate results in recursive plpgsql functions
Дата
Msg-id
2514.1015021461@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: storing intermediate results in recursive plpgsql functions Fran Fabrizio <ffabrizio@mmrd.com>
Re: storing intermediate results in recursive plpgsql functions Tom Lane <tgl@sss.pgh.pa.us>
Re: storing intermediate results in recursive plpgsql Vince Vielhaber <vev@michvhf.com>
Re: storing intermediate results in recursive plpgsql functions Tom Lane <tgl@sss.pgh.pa.us>
Fran Fabrizio  writes:
> I feel like I'm missing something obvious.

Well, you could use a temp table if you access it via EXECUTEd commands.
Or you could use a non-temp table and just not unlock; let the unlock
happen at normal end of transaction.  The latter is probably easier.

			regards, tom lane
В списке pgsql-general по дате отправления
От: Francisco Reyes
Дата:
От: Greg Sabino Mullane
Дата:
Сообщение: PostgreSQL favicon.ico
FAQ