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