Message-ID: <43284E51.8000507@ualg.pt>
Date: Wed, 14 Sep 2005 17:22:41 +0100
From: Luis Sousa <llsousa@ualg.pt>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.7.8) Gecko/20050831 Debian/1.7.8-1sarge2
MIME-Version: 1.0
To: "pgsql-sql@postgresql.org" <Pgsql-sql@postgresql.org>
Subject: CREATE TEMPORARY TABLE ON COMMIT DROP
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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