Is there some clear reason why I can't using EXECUTE of a PREPAREd query as I can a SELECT statement in CREATE TABLE AS, INSERT, FROM clause, sub-selects, etc.? If not, wouldn't this be a very useful change?
You can already do CREATE TABLE AS ... EXECUTE.
I agree being able to use EXECUTE in more situations would be a good thing. Patches are welcome.
I'm not sure there's a lot of value in adding support for EXECUTE in subqueries, since you would still need to do parsing, rewriting and planning for the rest of the query; also, the fact that the plan for the EXECUTE has already been generated would limit the optimizer's ability to pullup subqueries and so forth.
-Neil
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
