On Sat, Jul 25, 2009 at 2:42 AM, Nick Boutelier<[email protected]> 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
