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

leon-pg@comvision.com 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