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

Reply via email to