Re: Re: how to implement add using upsert and trigger?

["yin.zhb@xxxxxxx" <yin.zhb@xxxxxxx>]

em， which is does not matter

---

yin.zhb@xxxxxxx

 

From: Dominique Devienne

Date: 2022-11-28 20:47

To: yin.zhb@xxxxxxx

CC: pgsql-general

Subject: Re: how to implement add using upsert and trigger?

On Mon, Nov 28, 2022 at 1:37 PM yin.zhb@xxxxxxx <yin.zhb@xxxxxxx> wrote:

>     on conflict(itemid) do update

>     set value = excluded.value + new.value, cnt = excluded.cnt +1 where excluded.itemid = new.itemid;

 

OT, but isn't `where excluded.itemid = new.itemid` redundant, given

`on conflict(itemid)`?

I'm asking more because I'm not sure, for my own education. Thanks, --DD