"Andrus Moor" <[EMAIL PROTECTED]> writes:
> CREATE TEMP TABLE t2 AS SELECT * FROM t1 ON COMMIT DROP;
> Causes ERROR: syntax error at or near "ON" at character 104
Not implemented, as the manual clearly states.
> How to implement this ?
Create the temp table with a plain CREATE, then fill it with
INSERT ... SELECT.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
