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
2006/2/17, Justin B. Kay <[EMAIL PROTECTED]>:
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? Yes, you can ( PostgreSQL 8.0.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5
Justin B. Kay wrote:
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.
I have done it by returning a ref cursor to the temp table.
I believe there are some ref cursor examples in the docs, if you can't
find any
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 exis
