PostgreSQL: Error: column of relation does not exist

Question

UPDATE master as m
SET m.husband = p.id
From per as p
where m.drid = p.drid AND p.address > 80000 AND p.address <= 154969

我有一个名为per的表，其中有一列名为id。基本上，我想将这些id复制到where子句上的另一个名为master的表中。

但是我得到一个错误说，列"m"的关系"主"不存在。M不是一列。我不确定我哪里出错了。

Answer 1

不如像下面这样试试;从SET操作中删除表别名m，使其为SET husband = p.id

UPDATE master m
SET husband = p.id
From per p
where m.drid = p.drid 
AND p.address > 80000 
AND p.address <= 154969

(OR)不使用表别名，如

UPDATE master 
SET husband = per.id
From per
where master.drid = per.drid 
AND per.address > 80000 
AND per.address <= 154969

更多