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.
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. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
