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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general