On Saturday, January 23, 2021, Condor <con...@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.
