Monthly Archives: June 2009

Macbook Pro Hard Drive Replacement

By Andrew Hopper | Published: June 4, 2009
My beloved Macbook keeps running out of space so I keep putting bigger hard drives in it.  The latest is a fabulously large 500GB Hitachi drive. The drive runs quiet and cool. Make sure to buy your new harddrive from Other World Computing. They have a great selection, great shipping policies, and [...]
Posted in Hardware | Tagged | Leave a comment

Postgres Update from function

By Andrew Hopper | Published: June 3, 2009
I always forgot the syntax of the Postgresql update from functionality UPDATE employees SET sales_count = sales_count + 1 FROM accounts WHERE accounts.name = 'Acme Corporation' AND employees.id = accounts.sales_person;
Posted in Postgresql | 1 Comment