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

[David Gagnon]

Hi all,

 I think the title says everything:-)
 I just what a way to create a TEMP for the current transaction only.  
If possible I don't want to create the TEMP table first, specify all 
column types, etc.

CREATE TEMP TABLE _T_CR1 AS
SELECT CRNUM, CRYPNUM, CRMONT, CRDATE, GLNUM, CRRRNUM, CRACNUM, GLDESC  
FROM CR INNER JOIN CS ON CR.CRNUM = CS.CSCRNUM AND CR.CRYPNUM = CS.CSYPNUM
       INNER JOIN GL ON CS.CSGLNUM = GL.GLNUM AND 1 = GL.GLSOCTRL
WHERE CRYPNUM = companyId
 AND DATEDIFF(DY, CRDATE, GETDATE()) >= _AGELIMITE
ON COMMIT DROP;


Thanks for your help
David


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general