Another TEMP table trick

test=> create table test (x int);
CREATE
test=> insert into test values (1);
INSERT
test=> insert into test values (2);
INSERT 19787 1
test=> select * from test;
x
-
2
(1 row)

test=> drop table test;
DROP
test=> select * from test;
x
-
1
(1 row)

test=> drop table test;
DROP

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026