Re: Request new version to support "on commit drop" for create temp table ... as select ? - Mailing list pgsql-sql

Got it. Thank you Tom!

> Scott Marlowe <scott.marlowe@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
>