Tom Lane wrote:
Colin Wetherbee <cww@xxxxxxxxxxxxxxxx> 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.
In 8.2:
cww=# BEGIN;
BEGIN
cww=# CREATE TEMP TABLE foo ON COMMIT DROP AS (SELECT 1 AS a, 2 AS b);
SELECT
cww=# COMMIT;
COMMIT
cww=# \d foo
Did not find any relation named "foo".
Handy!
Colin
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
