Re: [HACKERS] INSERT ... ON CONFLICT DO UPDATE with _any_ constraint

[Geoff Winkless]

On 19 May 2015 at 21:57, Simon Riggs <si...@2ndquadrant.com> wrote:

> It's not clear to me how a single INSERT could cause two or more UPDATEs.
>

​
CREATE TABLE mytable (
  c1 int NOT NULL,
  c2 int NOT NULL,
  PRIMARY KEY (c1),
  UNIQUE (c2)​

​);

INSERT INTO mytable (c1, c2) (10, 20);​
INSERT INTO mytable (c1, c2) (11, 21);
​INSERT INTO mytable (c1, c2) (10, 21) ON CONFLICT DO UPDATE .....
​
Or did you mean from a coding point of view how it would be possible to
implement?

​Geoff​