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