Hi all,
I'm tryng to write query that on commit drops the temporary table but
I'm doing someting wrong.
According do documentation, I can create a temporary table using this
syntax:
CREATE TEMP TABLE table_name AS SELECT * from table_select;
or I can create a table like this:
CREATE TEMP TABLE table_name (fld1 integer) ON COMMIT DROP;
But how can I create a table using a query and putting ON COMMIT DROP.
Putting this on the end of the first sentence (CREATE TEMP TABLE
table_name AS SELECT * from table_select ON COMMIT DROP;) gives the
ERROR: syntax error at or near "ON" at character 60.
Thanks in advance for you answers.
Luis Sousa
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
