Le 27/10/08 13:12, Tom Lane a écrit :
In that case you just do EXECUTE 'SELECT ...
regards, tom lane
Hem... I feel quite stupid, but you're (again) right. It now run perfectly.
By the way, I said previously that EXECUTE does not allow to put the
results into a target. I was wrong again.
(cf.
<http://www.postgresql.org/docs/8.3/static/plpgsql-statements.html>,
chapter "38.5.4. Executing Dynamic Commands").
EXECUTE command-string [ INTO [STRICT] target ];
If I can make a suggestion, I think it could be interesting to complete
the doc with an additionnal example with such a EXECUTE that put results
in a target.
Thanks for the light ! :-)
Regards,
--
Bruno Baguette
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
