Re: PLPGSQL: Using SELECT INTO and EXECUTE

Tom,

Thanks for the input.. but shortly after sending the post I found the
document outlining the conversion from Oracle PL/SQL to Postgres
PLPGSQL. SELECT INTO is not supported by EXECUTE... and that in place
of SELECT INTO one should use the FOR...EXECUTE command. Thanks again
for your timely response...

Regards,

Michael Dunn

Tom Lane wrote:

>Michael Dunn <michael(at)2cactus(dot)com> writes:
>
>>Can EXECUTE handle a SELECT INTO statement within a plpgsql function.
>>
>
>SELECT INTO doesn't mean the same thing in plpgsql as it does in regular
>SQL. Use CREATE TABLE AS, instead.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
>