[EMAIL PROTECTED] writes: > Is there a better way to write this? > delete > from tbldata > where unitID || '_' || variableID || '_' || cycleID in > (select unitID || '_' || variableID || '_' || cycleID from > temp_data_table)
delete
from tbldata
where (unitID, variableID, cycleID) in
(select unitID, variableID, cycleID from temp_data_table)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
