temp tables in functions?
От
jws
Тема
temp tables in functions?
Дата
Msg-id
1170909609.908314.91930@q2g2000cwa.googlegroups.com
Список
Дерево обсуждения
temp tables in functions? "jws" <jsacksteder@gmail.com>
Re: temp tables in functions? Bruno Wolff III <bruno@wolff.to>
Re: temp tables in functions? "Shoaib Mir" <shoaibmir@gmail.com>
Re: temp tables in functions? Michael Fuhr <mike@fuhr.org>
Re: temp tables in functions? "Shoaib Mir" <shoaibmir@gmail.com>
Having developed a complex query, I want to wrap it up as a function so that it can take a parameter and return a set of rows. This query is currently written as multiple sql statements that create a few interstitial temp tables that are then joined. If I put this into a function definition, do those temp tables get dropped automatically when the function returns? My alternative is to re-write the query as a self joins and subqueries. I can do that, but it's somewhat less readable.
В списке pgsql-general по дате отправления