postgresql update column from select

Question

I am attempting to update a column from one table with a select query.

It runs and updates the entire type_ column as religious (text field).

I am trying to only update the rows where the religious geometry intersects the parcel geometry.

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

What is t.religious in that query? Without that part, it might work, though type_ seems like a strange choice for a column name. — Erich Kitzmueller
– Erich Kitzmueller, Commented Jun 3, 2017 at 16:05

Gordon Linoff · Accepted Answer · 2017-06-03 16:47:35Z

13

I think this is what you want:

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

answered Jun 3, 2017 at 16:47

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mahdi Moghimi · Accepted Answer · 2022-07-19 14:21:44Z

0

I Use PgAdmin4 and last version of PostgreSQL and this query works for me:

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

Hope help someone else!

answered Jul 19, 2022 at 14:21

Mahdi Moghimi

5881 gold badge7 silver badges22 bronze badges

Collectives™ on Stack Overflow

postgresql update column from select

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related