Re: return setof and Temp tables

On Friday 17 February 2006 00:13, Justin B. Kay wrote:
> I have looked around and found that you can use return setof in a
> function to return a result set, but can you use a temp table as the
> setof target?  I build a temp table using various select statements and
> then try to return the result as a recordset.  I get an error: type t1
> does not exist.
> If this is not possible, is there some alternative way to do this?  I am
> trying to translate what was done in a ms sql database.
>

If I were doing this, I would create a seperate permanent type that's
structure matched that of the temp table, or use out parameters to mimic it.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL