Title: Update with records from another table
Topics: blog, PostgreSQL
Date: 2010-07-01

Stefan Hornburg (Racke)

Update with records from another table 


update subject_cloud set count = count + 1 from (select subject from subjects where sku = '9780520241329') as subs where subs.subject = subject_cloud.subject;