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