Re: functions and temporary tables - Mailing list pgsql-general

From Tom Lane
Subject Re: functions and temporary tables
Date
Msg-id 20198.1076343400@sss.pgh.pa.us
Whole thread Raw
In response to functions and temporary tables  ("anorakgirl" <postgres@anorakgirl.co.uk>)
List pgsql-general
"anorakgirl" <postgres@anorakgirl.co.uk> writes:
> ... i can't
> work out how to get the data back out of my temporary table, as i don't
> think i can get the results of a select performed using EXECUTE?

At present you have to use a FOR IN EXECUTE loop, even if you only
expect one row out of the SELECT.

            regards, tom lane

pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: TSearch and rankings
Next
From: Joe Lester
Date:
Subject: Increasing Max Connections Mac OS 10.3