Re: Is there a RECORD[] type in plpgsql?

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: Is there a RECORD[] type in plpgsql?
Дата
Msg-id 20090725124743.GK5407@samason.me.uk
обсуждение исходный текст
Ответ на Is there a RECORD[] type in plpgsql?  (Nick Boutelier <namethisapp@gmail.com>)
Список pgsql-general
On Fri, Jul 24, 2009 at 11:42:07PM -0700, Nick Boutelier wrote:
> Im using the same...
>
> FOR record_or_row IN query LOOP
>
> at the beginning of a function and at the end of a function. Is there
> a way to save the query results in a RECORD[] type so that I don't
> have to run the query twice?

Wouldn't that be a temporary table?

--
  Sam  http://samason.me.uk/

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

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: Very slow joins
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Is there a RECORD[] type in plpgsql?