On Mon, Apr 27, 2015 at 1:19 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
> it appears that they are using quite a different syntax. The ON
> CONFLICT clause is attached to a constraint, specifying the default
> action for that constraint. The INSERT command can then override this
> default choice. I think.
Well, MySQL's ON DUPLICATE KEY UPDATE thing is pretty close to what I
have. I intend CONFLICT as a broader term, which is somewhat similar
to SQLite (and is not needlessly verbose).
--
Peter Geoghegan