On 2019-11-08 09:03, Pavel Stehule wrote: > Parse analysis of EXECUTE does not access any tables, so if I > understood > this correctly, this concern doesn't apply here. > > > it should not be true - the subquery can be a expression.
Arguments of EXECUTE cannot be subqueries.
ok
> Minimally on SQL level is not possible do prepare on execute. So execute > should be evaluate as one step.
Well, that's kind of the question that is being discussed in this thread.
I say it not cleanly - I think so this change should be safe, because parsing, transforming, and execution must be in one statement.
Regards
Pavel
-- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services