Delete with a multi-column join?

Поиск
Список
Период
Сортировка
От leon-pg@comvision.com
Тема Delete with a multi-column join?
Дата
Msg-id 60F7901C-6F16-11D9-A24C-000A95E07710@comvision.com
обсуждение исходный текст
Ответы Re: Delete with a multi-column join?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Delete with a multi-column join?  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Ben
Дата:
Сообщение: Re: Apparently I don't understand full outer joins....
Следующее
От: John DeSoi
Дата:
Сообщение: Re: Postgresql, SQL server and Oracle. Please, help