Postgres Update With Join
April 20, 2016 · postgres cte update
How to perform and update with a join using CTE’s in postgres
- in a cte, write a select that returns the update to values, and the join on conditions
- join on that in the update
- Test: Optionally write a select that tests your results and wrap it all in a rolled back transaction to test run