News for hackers. Stuff that matters.
Re:Upsert Lands in PostgreSQL 9.5 – A First Look by jeffdavis on Wednesday May 13, 2015 @01:21PM (#9540483)
"DO UPDATE SET description=description;"

I think that should be:

"DO UPDATE SET description=excluded.description;"

And doesn't it also need an inference clause or constraint specification for DO UPDATE?

Please update example code to be self-contained, so that readers can copy/paste.

The example itself -- upserting product descriptions from another data source -- is a great one though.

Re:Upsert Lands in PostgreSQL 9.5 – A First Look by craigkerstiens on Wednesday May 13, 2015 @02:09PM (#9540841)
Hi, Jeff

Will update as soon as I'm at a machine, but yes of course you're correct.