Re^2: [OT] SQL "on duplicate key" custom action

[erix]

Do you perhaps have a tested version? I can't get this to run.

The trigger functions are all right, it seems, but I don't see how to create the triggers themselves onto the table 'records' so that they react in the desired way. (For one thing, you can't do an 'INSTEAD OF UPDATE' on a table, and when you use a BEFORE INSERT or an AFTER INSERT trigger, this old. and new. business is not going to work.)

[Corion]

No, sorry - I don't have a tested version, and I'm not on the machine where I did the searches.

I worked from the Postgres 12 documentation and some Stackoverflow response, but I don't find them now :( I think it should be a before update trigger and the statement would be insert or update maybe. But again, I didn't test any of this, sorry.