Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a RECORD[] type in plpgsql? - Mailing list pgsql-general

From Sam Mason
Subject Re: Is there a RECORD[] type in plpgsql?
Date
Msg-id 20090725124743.GK5407@samason.me.uk
Whole thread Raw
In response to Is there a RECORD[] type in plpgsql?  (Nick Boutelier <namethisapp@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Sam Mason
Date:
Subject: Re: Very slow joins
Next
From: Merlin Moncure
Date:
Subject: Re: Is there a RECORD[] type in plpgsql?