Re: PL/pgSQL bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PL/pgSQL bug?
Date
Msg-id 24794.1001955506@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL/pgSQL bug?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
>> AFAIK the only workaround at present is to use
>> EXECUTE for queries referencing the temp table.

> But EXECUTE does not support select into, does it?

You could probably get the result you want usingFOR rec IN EXECUTE text_expression LOOP ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: [ODBC] UTF-8 support
Next
From: Vince Vielhaber
Date:
Subject: Re: developer's faq