Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Colin Wetherbee <cww(at)denterprises(dot)org>
Cc: Adrian Klaver <aklaver(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP
Date: 2008-03-13 22:19:50
Message-ID: 23959.1205446790@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Colin Wetherbee <cww(at)denterprises(dot)org> writes:
> Adrian Klaver wrote:
>> Try CREATE TEMP TABLE foo ON COMMIT DROP AS (SELECT 1 AS a, 2 AS b) ;

> I don't know what version the OP is using, but that doesn't work on 8.1:

Seems to be there in 8.2 and up.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Colin Wetherbee 2008-03-13 22:22:25 Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP
Previous Message Colin Wetherbee 2008-03-13 21:51:53 Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP