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

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Is there a RECORD[] type in plpgsql?
Date: 2009-07-25 12:47:43
Message-ID: 20090725124743.GK5407@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-07-25 13:29:23 Re: Is there a RECORD[] type in plpgsql?
Previous Message Sam Mason 2009-07-25 12:45:01 Re: Very slow joins