On Saturday, January 23, 2021, Condor <
condor@stz-bg.com> wrote:
Hello ppl,
I need help with trigger how to replace insert command with update. External program read data from one table and in every 30 min I need to refresh data in arhive table.
What I want is: if data already inserted and end_date is not changed, only to update lastseen column. If data not exists to insert data and if data exists and end_date is changed
to update end_date, lastseen and sendto columns. Well, update probably will never happened, this functionality is left for frontend but its can be cut off.
Seems like an insert on conflict would be simpler. Otherwise, what is your question or concern?
David J.