Pavel Stehule <pavel.stehule@gmail.com> wrote:
> PostgreSQL doesn't support a table variables
Well, from a relational theory point of view, a variable which
stores a relation is what a table *is*. PostgreSQL attempts to
store data for temporary tables in RAM and spill them to disk only
as needed. So IMO the response suggesting a temporary table was on
target.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company