ban-duplicate-column-assignments

problem

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

create table t(a int, a text);
create view v (a, a) as select 1, 2;
update t set a = 1, a = 2;

solution

Remove duplicate assignments/declarations:

create table t(a int);
create view v (a, b) as select 1, 2;
update t set a = 2;