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. Justin |
- [GENERAL] return setof and Temp tables Justin B. Kay
- Re: [GENERAL] return setof and Temp tables Tony Caduto
- Re: [GENERAL] return setof and Temp tables William Leite Araújo
- Re: [GENERAL] return setof and Temp tables Robert Treat