Re: [HACKERS] CREATE TABLE AS ... EXECUTE

2003-06-27 Thread Peter Eisentraut
Alvaro Herrera Munoz writes: > Is there a way to create a table from a prepared statement? CREATE TABLE AS > explicitly says you have to use a SELECT statement, and the SELECT INTO > syntax doesn't seem to allow the use of a prepared statement either. I > don't see a way to use the prepared stat

Re: [HACKERS] CREATE TABLE AS ... EXECUTE

2003-06-27 Thread Tom Lane
Alvaro Herrera Munoz <[EMAIL PROTECTED]> writes: > Is there a way to create a table from a prepared statement? CREATE TABLE AS > explicitly says you have to use a SELECT statement, and the SELECT INTO > syntax doesn't seem to allow the use of a prepared statement either. IIRC there is an EXECUTE

[HACKERS] CREATE TABLE AS ... EXECUTE

2003-06-27 Thread Alvaro Herrera Munoz
Hackers, Is there a way to create a table from a prepared statement? CREATE TABLE AS explicitly says you have to use a SELECT statement, and the SELECT INTO syntax doesn't seem to allow the use of a prepared statement either. I don't see a way to use the prepared statement as a function nor as a