Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ozdiB-0005L4-R0 for pgsql-general@arkaria.postgresql.org; Mon, 28 Nov 2022 12:58:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ozdi9-0004Lg-1v for pgsql-general@arkaria.postgresql.org; Mon, 28 Nov 2022 12:58:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ozdi8-0004LW-NI for pgsql-general@lists.postgresql.org; Mon, 28 Nov 2022 12:58:12 +0000 Received: from m12.mail.163.com ([220.181.12.216]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ozdi3-0004wF-L9 for pgsql-general@lists.postgresql.org; Mon, 28 Nov 2022 12:58:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Date:From:Subject:Mime-Version:Message-ID; bh=n9BFS VL8+63gU51K3JjEPmcgJfyLJvHDxIdCVohyk6c=; b=bXHNt+xry9/iy9/tjUDSP KbLZIkGWZMHVgWJSsV6IOYMH7LryLS0a6tpuyTsO00aN+IJFKcyfhnCgA6rgKO+b x8yR/40ECNAPD82tj5mnnejQ+wE6qgyKXiVEKH9Z3E/rUIRSxlGODYjMNkgaSUD0 GWNFIlkVj0GOGlej5259rU= Received: from xin-PC (unknown [221.231.169.83]) by zwqz-smtp-mta-g0-2 (Coremail) with SMTP id _____wBnBL5VsIRjE1P5AA--.55250S2; Mon, 28 Nov 2022 20:57:57 +0800 (CST) Date: Mon, 28 Nov 2022 20:57:58 +0800 From: "yin.zhb@163.com" To: "Dominique Devienne" Cc: pgsql-general Subject: Re: Re: how to implement add using upsert and trigger? References: <202211282037367351626@163.com>, X-Priority: 3 X-GUID: A367DD0D-6D0D-4901-95B3-29C9AADF3128 X-Has-Attach: no X-Mailer: Foxmail 7.2.25.148[cn] Mime-Version: 1.0 Message-ID: <202211282057577060707@163.com> Content-Type: multipart/alternative; boundary="----=_001_NextPart217123681060_=----" X-CM-TRANSID: _____wBnBL5VsIRjE1P5AA--.55250S2 X-Coremail-Antispam: 1Uf129KBjDUn29KB7ZKAUJUUUUU529EdanIXcx71UUUUU7v73 VFW2AGmfu7bjvjm3AaLaJ3UbIYCTnIWIevJa73UjIFyTuYvj4R_zVbUUUUU X-Originating-IP: [221.231.169.83] X-CM-SenderInfo: h1lqh6lke6il2tof0z/xtbB2A-HB2BHMshbMgAAsj List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. ------=_001_NextPart217123681060_=---- Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 ZW3vvIwgd2hpY2ggaXMgZG9lcyBub3QgbWF0dGVyDQoNCg0KeWluLnpoYkAxNjMuY29tDQogDQpG cm9tOiBEb21pbmlxdWUgRGV2aWVubmUNCkRhdGU6IDIwMjItMTEtMjggMjA6NDcNClRvOiB5aW4u emhiQDE2My5jb20NCkNDOiBwZ3NxbC1nZW5lcmFsDQpTdWJqZWN0OiBSZTogaG93IHRvIGltcGxl bWVudCBhZGQgdXNpbmcgdXBzZXJ0IGFuZCB0cmlnZ2VyPw0KT24gTW9uLCBOb3YgMjgsIDIwMjIg YXQgMTozNyBQTSB5aW4uemhiQDE2My5jb20gPHlpbi56aGJAMTYzLmNvbT4gd3JvdGU6DQo+ICAg ICBvbiBjb25mbGljdChpdGVtaWQpIGRvIHVwZGF0ZQ0KPiAgICAgc2V0IHZhbHVlID0gZXhjbHVk ZWQudmFsdWUgKyBuZXcudmFsdWUsIGNudCA9IGV4Y2x1ZGVkLmNudCArMSB3aGVyZSBleGNsdWRl ZC5pdGVtaWQgPSBuZXcuaXRlbWlkOw0KIA0KT1QsIGJ1dCBpc24ndCBgd2hlcmUgZXhjbHVkZWQu aXRlbWlkID0gbmV3Lml0ZW1pZGAgcmVkdW5kYW50LCBnaXZlbg0KYG9uIGNvbmZsaWN0KGl0ZW1p ZClgPw0KSSdtIGFza2luZyBtb3JlIGJlY2F1c2UgSSdtIG5vdCBzdXJlLCBmb3IgbXkgb3duIGVk dWNhdGlvbi4gVGhhbmtzLCAtLUREDQogDQo= ------=_001_NextPart217123681060_=---- Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable =0A
em=EF=BC=8C which is doe= s not matter

=0A
yin.zhb@163.com
=0A
 
Date: 2022-11-28 20:47
To: yin.zhb@163.com
Subject: Re: how to implement= add using upsert and trigger?
On Mon, Nov 28, = 2022 at 1:37 PM yin.zhb@163.com <yin.zhb@163.com> wrote:
=0A>     on conflict(itemid) do update
=0A
= >     set value =3D excluded.value + new.value, cnt= =3D excluded.cnt +1 where excluded.itemid =3D new.itemid;
=0A
&n= bsp;
=0A
OT, but isn't `where excluded.itemid =3D new.itemid` red= undant, given
=0A
`on conflict(itemid)`?
=0A
I'm asking = more because I'm not sure, for my own education. Thanks, --DD
=0A =0A
=0A ------=_001_NextPart217123681060_=------