In Postgres, an UPDATE is effectively an INSERT + DELETE [0].

0: https://www.cybertec-postgresql.com/en/is-update-the-same-as...