Maybe this example will help.
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 CONFLICT (did) DO UPDATE
SET dname = EXCLUDED.dname || ' (formerly ' || d.dname || ')'
WHERE d.zipcode <> '21201';
On Sat, Jan 23, 2021 at 3:47 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
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.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
