"Andrus Moor" <eetasoft@xxxxxxxxx> 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 majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
