I use this command for create TEMPORARY TABLE now affter use this temporary i want DROP this Table but NOT WORk IF EXIST TEMPORARY TABLE in PGsql 8.1 for this please help me
SELECT connection_log_details.connection_log_id, textcat_all(connection_log_details.value || '|') INTO TEMPORARY log FROM connection_log_details GROUP BY connection_log_details.connection_log_id limit 2010; select * from log; DROP TABLE log; and i useaggre gate in pgsql 8 and for test use this not have CREATE if exist AGGREGATE please help me