在插入时：将列引用“得分”模棱两可 [英] On Insert: column reference "score" is ambiguous

问题描述

我在PostgreSQL中有以下命令：

I have the following command in postgresql:

INSERT INTO word_relations(word1_id, word2_id, score) VALUES($1, $2, $3)
ON CONFLICT (word1_id, word2_id) DO UPDATE SET score = score + $3`)

我得到以下错误：

column reference "score" is ambiguous

我认为这很奇怪，因为我只使用一张桌子。有任何想法吗？

I thought it was odd as I am only using one table. Any ideas?

推荐答案

位于 = 右侧 set 子句，分数有两种可能： EXCLUDED.score 和 word_relations.score 。前者是一种访问所插入值的方法；

On the right side of the = in the set clause, there are two possibilities for score: EXCLUDED.score and word_relations.score. The former is a way of accessing the value being inserted; the latter a way of accessing the value stored in the row.

我将其写为：

ON CONFLICT (word1_id, word2_id) DO
    UPDATE SET score = word_relations.score + EXCLUDED.score

这篇关于在插入时：将列引用“得分”模棱两可的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！