Search Postgresql Archives

return setof and Temp tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux