Betsy Barker <betsy.barker@supportservicesinc.com> writes:
> I'm building a function that utilizes a temporary table and I am doing
> a SELECT INTO variable from the table. I've read several posts about
> the EXECUTE, however I'm stuck because my error happens during the
> SELECT INTO a variable, and apparently the EXECUTE SELECT INTO has not
> been implemented in version 7.3.4.
The recommended workaround is to use FOR ... IN EXECUTE to collect the
results of your EXECUTE'd select into a record variable. It may seem a
little weird to use a FOR loop that you always intend to execute exactly
once, but until someone figures out a reasonable implementation of INTO
in EXECUTE, it's the only way.
regards, tom lane
