Quick Links

Is there a RECORD[] type in plpgsql?

From:	Nick Boutelier <namethisapp(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Is there a RECORD[] type in plpgsql?
Date:	2009-07-25 06:42:07
Message-ID:	df83c3c6-dd1d-4ac7-b92d-3280d15ec721@x25g2000prf.googlegroups.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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?

Responses

Re: Is there a RECORD[] type in plpgsql? at 2009-07-25 12:47:43 from Sam Mason
Re: Is there a RECORD[] type in plpgsql? at 2009-07-25 13:29:23 from Merlin Moncure

Browse pgsql-general by date

	From	Date	Subject
Next Message	Craig Ringer	2009-07-25 07:57:33	Re: Copying only incremental records to another DB..
Previous Message	Jan-Erik	2009-07-25 05:50:02	Re: split string by special characters