From: | Condor <condor(at)stz-bg(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Need help with trigger |
Date: | 2021-01-23 18:09:23 |
Message-ID: | 7dcfcb8bfaed656fe17dd6c76fe7fb22@stz-bg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 23-01-2021 18:17, David G. Johnston wrote:
> On Saturday, January 23, 2021, Condor <condor(at)stz-bg(dot)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.
This was my first approach, but as the sample data I provide, end_date
will always be updated not only if it is changed and my goal is to have
no meaningless records. My question is there a way to update the trigger
instead of inserting.
HS
From | Date | Subject | |
---|---|---|---|
Next Message | Condor | 2021-01-23 18:20:18 | Re: Need help with trigger |
Previous Message | Benedict Holland | 2021-01-23 17:03:45 | Re: Copy & Re-copy of DB |