em， which is does not matter
[email protected] From: Dominique Devienne Date: 2022-11-28 20:47 To: [email protected] CC: pgsql-general Subject: Re: how to implement add using upsert and trigger? On Mon, Nov 28, 2022 at 1:37 PM [email protected] <[email protected]> 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
