On Thursday 13 March 2008 4:49 am, David Gagnon wrote: > 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 I am missing something here. What is wrong with the above statement? -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
