Postgres, Need help updating only NULL values

Question

I have two tables 'A', 'B'. I want to write a query that accomplishes the results shown below.

currently I have this statement

UPDATE A
SET version = (
   SELECT B.version
   FROM B 
   WHERE B.id = A.id 
)

It works, but it updates ALL the rows, how can I write it so that only the null values are updated ?

Bjarni Ragnarsson · Accepted Answer · 2022-06-18 19:26:54Z

1

UPDATE A SET version = ( SELECT B.version FROM B WHERE B.id = A.id ) where A.version is null

answered Jun 18, 2022 at 19:26

Bjarni Ragnarsson

1,7811 gold badge8 silver badges8 bronze badges

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

1 Answer 1