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

From Merlin Moncure
Subject Re: Is there a RECORD[] type in plpgsql?
Date
Msg-id b42b73150907250629o3faa099iad76a044659bb7c8@mail.gmail.com
Whole thread Raw
In response to Is there a RECORD[] type in plpgsql?  (Nick Boutelier <namethisapp@gmail.com>)
List pgsql-general
On Sat, Jul 25, 2009 at 2:42 AM, Nick Boutelier<namethisapp@gmail.com> 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?

yes (in postgresql 8.3).  This is often a little more convenient than
a temporary table.

merlin

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Is there a RECORD[] type in plpgsql?
Next
From: Andreas Wenk
Date:
Subject: Re: Disable databse listing for non-superuser (\l) ?