Using EXECUTE in same manner as SELECT

[Andrew Lazarus]

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? (Or is
there some special syntax to do this that I can't find?)

Andrew Lazarus an****@pillette.com
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Neil Conway]

Andrew Lazarus wrote:

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