PL pgSQL - UPDATE JOIN

Page / - Изменено Alexandr Fokin в 2023/12/16 14:12

UPDATE JOIN

Изменено Alexandr Fokin

в 2023/12/16 14:12

Оглавление

update tmpTable1 as t1
set
property1 = dt.property1
from
(
select query...
) as dt
where t1.id = dt.id

How to do an update + join in PostgreSQL?
https://stackoverflow.com/questions/7869592/how-to-do-an-update-join-in-postgresql