error_on_nondeterministic_update
值(默认为粗体)
false, true
描述
指定每行具有多个匹配项的 UPDATE 查询是否返回错误。
示例
SET error_on_nondeterministic_update TO true; CREATE TABLE t1(x1 int, y1 int); CREATE TABLE t2(x2 int, y2 int); INSERT INTO t1 VALUES (1,10), (2,20), (3,30); INSERT INTO t2 VALUES (2,40), (2,50); UPDATE t1 SET y1=y2 FROM t2 WHERE x1=x2; ERROR: Found multiple matches to update the same tuple.