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.
Will update as soon as I'm at a machine, but yes of course you're correct.
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.