Delete with a multi-column join? - Mailing list pgsql-general

Howdy! I apologize in advance for the ugly query I'm about to throw
your way....

I need to delete some data from a table based on a multi-column join.
Is there a better way to write this?

delete
from tbldata
where unitID || '_' || variableID || '_' || cycleID in
    (select unitID || '_' || variableID || '_' || cycleID from
temp_data_table)

In SQL Server I would just write

delete tblData
from tblData a
    inner join temp_data_table b
        on a.unitID = b.unitID
            and a.variableID = b.variableID
            and a.cycleID = b.cycleID