Re: INSERT ... ON CONFLICT syntax issues - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: INSERT ... ON CONFLICT syntax issues
Date
Msg-id CAM3SWZSy_7A+St+1cHqYqTPmM3PSp6mJ_YQhDUziuJ4qF4XP3Q@mail.gmail.com
Whole thread Raw
In response to Re: INSERT ... ON CONFLICT syntax issues  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Dave Jones
Date:
Subject: Re: Temporal extensions
Next
From: Fabien COELHO
Date:
Subject: PATCH: pgbench - remove thread fork-emulation