I Am pretty certain that would get the job done in MySQL (my track record), but it would not feel to work in postgres. The error I get is: The SET statement is employed While using the UPDATE assertion to assign new values to columns obtaining outdated values. This website https://pgupdate.in/