Equivalent of a RECORD[] data type used in a function?

From: nboutelier(at)hotmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Equivalent of a RECORD[] data type used in a function?
Date: 2006-02-01 04:42:41
Message-ID: 1138768961.781744.70120@g14g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to have a function variable hold a recordset? Kind of
like this...

DECLARE
recordset_var RECORD[];
BEGIN
recordset_var := (SELECT id FROM myTable);
/*
loop through a ton of different tables where column IN
(recordset_var)
*/
END;

Thanks for any help! -Nick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Hixson 2006-02-01 06:37:47 returning a cursor from a function?
Previous Message James Harper 2006-02-01 02:51:00 Re: libpq questions