Re:Upsert Lands in PostgreSQL 9.5 – A First Look
by mbreese on Wednesday May 13, 2015 @12:19PM
(#9540049)
The syntax looks inconvenient, but I like it. If you have a conflict, you might not want to just update everything, but only a subset of the fields. With this syntax (verbose as it is), you have the option of explicitly stating what you want to happen in the event of a conflict with no ambiguity. Perhaps there is a place for some shorthand like
But aside from that, for a RDBMS like Postgres, I'd opt for explicit over implicit.
[ Parent
| on HN ]