Adrian Klaver <[EMAIL PROTECTED]> writes: > On Thursday 23 November 2006 08:45 pm, Tom Lane wrote: >> This should work --- in PG 8.1 or later.
> The documentation for pl/pgsql in 8.1 and higher says different. > http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN > " SELECT INTO is not currently supported within EXECUTE." That says you can't do EXECUTE 'select ... into foo ...'; which is not the same thing as EXECUTE 'select ...' into foo; regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate