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

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Nick Boutelier <namethisapp(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is there a RECORD[] type in plpgsql?
Date: 2009-07-25 13:29:23
Message-ID: b42b73150907250629o3faa099iad76a044659bb7c8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Jul 25, 2009 at 2:42 AM, Nick Boutelier<namethisapp(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Wenk 2009-07-25 13:53:15 Re: Disable databse listing for non-superuser (\l) ?
Previous Message Sam Mason 2009-07-25 12:47:43 Re: Is there a RECORD[] type in plpgsql?