Re: Delete with a multi-column join?

[Tom Lane <tgl@xxxxxxxxxxxxx>]

leon-pg@xxxxxxxxxxxxx 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