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