Re: [SQL] Request new version to support "on commit drop" for create temp table ... as select ?

[Emi Lu]

Got it. Thank you Tom!

Scott Marlowe <scott.marl...@gmail.com> writes:

That's what I thought, but

create temp table xyz as select * from abc on commit drop;

still fails on 8.3.  Was this fixed in 8.4 or is my syntax wonky?

Your syntax is wonky -- switch the clause order.
http://www.postgresql.org/docs/8.3/static/sql-createtableas.html

                        regards, tom lane

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql