postgreql从选择更新列

Question

我正在尝试使用选择查询更新一个表中的列。

它运行并更新整个type_列作为宗教（文本字段）。

我尝试仅更新宗教几何与宗地几何相交的行。

update wash_parcels_final
set    type_ = t.religious 
from   (select wash_worship.religious 
        from   wash_parcels_final 
        join   wash_worship 
        on     st_intersects(wash_worship.geom, wash_parcels_final.geom)) t

Answer 1

我使用PgAdmin4和最新版本的PostgreSQL，这个查询对我有用：

update public."UserPoints"
set "AvailablePoints" = up."AvailablePoints" + tc."CLV"
from public."UserPoints" up join public."TEMPCLV" tc on up."UserId" = tc."CUSTOMER_NUMBER"

希望帮助别人！

Answer 2

我想这就是你想要的：

update wash_parcels_final
    set type_ = ww.religious 
    from wash_worship ww  
    where st_intersects(ww.geom, wash_parcels_final.geom);