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