ban-duplicate-column-assignments

problem

Assigning to a column more than once in Postgres results in a runtime error.

create table t(a int);
update t set a = 1, a = 2;

gives:

Query 1 ERROR at Line 1: : ERROR:  multiple assignments to same column "a"

solution

Remove your dupe assignment:

update t set a = 2;