http://www.perlmonks.org?node_id=11107769


in reply to Re: [OT] SQL "on duplicate key" custom action
in thread [OT] SQL "on duplicate key" custom action

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.)

Replies are listed 'Best First'.
Re^3: [OT] SQL "on duplicate key" custom action
by Corion (Patriarch) on Oct 21, 2019 at 16:34 UTC

    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.