armand pirvu <armand.pi...@gmail.com> wrote:
But what if in the conflict situation I want to performa the update ONLY if the record is different. The update seems to happen no matter what In other words is there anyway I can filter the update to happen (based on the sample date) only for 112 since col2 is different ?
That's quite possible. An ON CONFLICT's UPDATE accepts a WHERE clause, which can reference both existing and excluded tuples. That WHERE clause can back out of the UPDATE based on whatever criteria you like. -- Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
