只需将两个键放在
ON CONFLICT子句中：
INSERT INTO answer VALUES (1,1,'q1') ON ConFLICT (person_id,question_id) DO UPDATe SET answer = EXCLUDED.answer;
例子：
INSERT INTO answer VALUES (1,1,'q1') ON ConFLICT (person_id,question_id) DO UPDATE SET answer = EXCLUDED.answer;SELECT * FROM answer; person_id | question_id | answer -----------+-------------+-------- 1 |1 | q1(1 Zeile)INSERT INTO answer VALUES (1,1,'q1-UPDATeD') ON ConFLICT (person_id,question_id) DO UPDATE SET answer = EXCLUDED.answer;SELECT * FROM answer; person_id | question_id | answer -----------+-------------+------------ 1 |1 | q1-UPDATED(1 Zeile)
