INSERT INTO distributors AS d (did, dname) VALUES (8, 'Anvil Distribution') ON CONFLICT (did) DO UPDATE SET dname = EXCLUDED.dname || ' (formerly ' || d.dname || ')' WHERE d.zipcode <> '21201';
On 1/23/21 12:14 PM, Condor wrote: > On 23-01-2021 20:49, Adrian Klaver wrote: >> On 1/23/21 10:20 AM, Condor wrote:
> > Sorry, > > I'm sorry, I don't understand something. You mean to do pure INSERT ON > CONFLICT DO or to modify the trigger ?
No I meant that in the external program you use to fetch the data from the other table and reorganize the fields. Do your test there and do either the INSERT or UPDATE.