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 по дате отправления
От: jws
Дата:
Сообщение: Re: 'greatest' function?
От: roopa perumalraja
Дата:
FAQ