Thank you, this result is what I want
yin@163.com
From: Pavel Luzanov
Date: 2022-11-28 21:26
To: yin@163.com; pgsql-general
Subject: Re: how to implement add using upsert and trigger?
Hi, I think you need:
insert into stat_result(itemid,value,cnt) values(new.itemid, new.value, 1
em， which is does not matter
yin@163.com
From: Dominique Devienne
Date: 2022-11-28 20:47
To: yin@163.com
CC: pgsql-general
Subject: Re: how to implement add using upsert and trigger?
On Mon, Nov 28, 2022 at 1:37 PM yin@163.com wrote:
> on conflict(itemid) do update
>
)
But I want it is "100 3 3". So how I can do?
yin....@163.com
