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 andrew@pillette .com


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Neil Conway]

Re: Using EXECUTE in same manner as SELECT

Andrew Lazarus wrote:[color=blue]
> 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?[/color]

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