Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wrBGa-000C9F-0z for pgsql-general@arkaria.postgresql.org; Tue, 04 Aug 2026 09:16:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wrBGY-005Dt0-28 for pgsql-general@arkaria.postgresql.org; Tue, 04 Aug 2026 09:16:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wquQW-000rXh-1c for pgsql-general@lists.postgresql.org; Mon, 03 Aug 2026 15:18:05 +0000 Received: from rex-mailout.bayern.de ([193.34.207.154]) by makus.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wquQT-000000001Ez-0bKJ for pgsql-general@lists.postgresql.org; Mon, 03 Aug 2026 15:18:04 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1785770281; x=1801322281; h=from:to:subject:date:message-id:references:in-reply-to: content-type:content-transfer-encoding:mime-version; bh=/WyFzmblYc6ru4MLZpeuKyovMFXGnXw9JLTKb/AYoNs=; b=JV5u13sQcgmNV+b/BYgm+LILG9or+GFojSdDWlVukqkxhOK5NYF5Z4h2 GOxbHB9xzU2VEe8+8Y8TPIPhsp2nqsEPXgskfNLHifyhrCXQiju8BbcxV y+CoZ3IHcUQva1KYV9fi6arITEQru7No/kF+kSr2t5xVq+muCwC6lD0Yo wmJ+MshleG6hJjFYOoLLNSPhZTT3j0krVgwXBe0MK3seetf5x1XxtX2hd SQmjaQBLkiWDzksPW/g/35Lu8uzs/PcNZZEsoFfEsAhPecu9qAxvUNpLh OaV74ie6I7HOBt6tEJMDFfB55MpqZ1aP7Og4QCUpM0iZEx09sqN0PPvl5 A==; X-CSE-ConnectionGUID: /l1bXPU6TdCkwVkXcrBQKw== X-CSE-MsgGUID: oRwR3DmZTOiTSdVe7KL6jQ== Received: from unknown (HELO rin133.bayern.de) ([10.197.20.133]) by rex132.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 03 Aug 2026 17:17:56 +0200 X-CSE-ConnectionGUID: PcL6Ri3WSoCEGRfT8cfUvg== X-CSE-MsgGUID: 6KCCwsGfSKuVOErv7TRqfQ== X-Talos-CUID: =?us-ascii?q?9a23=3A96DVcmiX98gVSydI4KTDUIo5+zJuSnb5kk3ReHC?= =?us-ascii?q?DDk1EZ4ebdQ+b9p56nJ87?= X-Talos-MUID: 9a23:6NrDnghCEI9HKejDxFwOUcMpauRDyLu1J042sog4nOSeK3NMAS6TtWHi X-BYBN-routing: post Received: from zmx-ej2-p25850.max.bayern.de ([10.173.241.200]) by rin133.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 03 Aug 2026 17:17:56 +0200 Received: from ZMX-EJ2-P25850.max.bayern.de (10.173.241.200) by ZMX-EJ2-P25850.max.bayern.de (10.173.241.200) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.2562.43; Mon, 3 Aug 2026 17:17:56 +0200 Received: from ZMX-EJ2-P25850.max.bayern.de ([10.173.241.200]) by ZMX-EJ2-P25850.max.bayern.de ([10.173.241.200]) with mapi id 15.02.2562.043; Mon, 3 Aug 2026 17:17:56 +0200 From: =?utf-8?B?RsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKQ==?= To: Adrian Klaver , "pgsql-general@lists.postgresql.org" Subject: AW: UPDATE myTable SET (myTable.*) = json_populate_record(...) ? Thread-Topic: UPDATE myTable SET (myTable.*) = json_populate_record(...) ? Thread-Index: Ad0jFoAeXZ2r+OooQsisX4RJ4+SO9QAMX5aAAARa6yA= Date: Mon, 3 Aug 2026 15:17:56 +0000 Message-ID: References: <688383b93cf74558b5b9484ca3c3996a@stmuk.bayern.de> In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.171.65.1] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk WWVzLCB0aGUgbGVhc3QgZ3JhdmUgb2YgbXkgaXRlbXMgY2FuIGJlIHdvcmtlZCBhcm91bmQgYnkg d3JhcHBpbmcgdGhlIGZ1bmN0aW9uIGludG8gYSBzdWJzZWxlY3QsIGZvciB3aGF0ZXZlciByZWFz b24gdGhpcyBtaWdodCBiZSBuZWNlc3NhcnkuDQooQXMgZmFyIGFzIEkga25vdyB0aGVyZSBhcmUg b3RoZXIgcGxhY2VzIGluIFBvc3RncmVzIHdoZXJlIEkgY2FuIHN1YnN0aXR1dGUgYSBzdWJzZWxl Y3QgYnkgYW4gZXhwcmVzc2lvbiAvIGEgZnVuY3Rpb24gY2FsbCwgYW5kIEkgYW0gY3VyaW91czog V2h5IG5vdCBoZXJlPykNCg0KQnV0IHdoYXQgYWJvdXQgbXkgb3RoZXIgaXRlbS4uLiB3aGF0IGFi b3V0IHNvbWVob3cgcHJldmVudGluZyB0byB3cml0ZSBhbGwgY29sdW1uIG5hbWVzLCBpLiBlLiBj aGFuZ2luZyAuLi4NCg0KICAgIFNFVCAoY29sMSwgY29sMiwgLi4uKQ0KDQouLi4gdG8gc29tZXRo aW5nIGxpa2UgLi4uDQoNCiAgICBTRVQgKG15VGFibGUuKikNCg0KPw0KDQoNCk15IGZpcnN0IGlu dGVudGlvbiBvbiBwb3N0aW5nIHdhczogSXMgdGhlcmUgc29tZSB3YXkgdG8gYWNoZWl2ZSB0aGF0 Pw0KDQpJZiBubywgbXkgc2Vjb25kIGludGVudGlvbiBpcyBhIGdlbmVyYWwgY3JpdGlxdWUgb24g Li4uIEkgdGhpbmsgaXQgaXMgYXQgbGVhc3Qgc2ltaWxhciB0byB3aGF0IGh0dHBzOi8vY2FybGlu ZW5nLmNvbS8/cG9zdGlkPXNxbC1jcml0aXF1ZSNibG9nIGNhbGxzICIgTGFjayBvZiBPcnRob2dv bmFsaXR5IiBpbiAoUG9zdGdyZXMtKVNRTC4NCg0KDQotLS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hy aWNodC0tLS0tDQpWb246IEFkcmlhbiBLbGF2ZXIgPGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+ IA0KR2VzZW5kZXQ6IE1vbnRhZywgMy4gQXVndXN0IDIwMjYgMTc6MDANCkFuOiBGw6RyYmVyLCBG cmFuei1Kb3NlZiAoU3RNVUspIDxGcmFuei1Kb3NlZi5GYWVyYmVyQHN0bXVrLmJheWVybi5kZT47 IHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmcNCkJldHJlZmY6IFJlOiBVUERBVEUg bXlUYWJsZSBTRVQgKG15VGFibGUuKikgPSBqc29uX3BvcHVsYXRlX3JlY29yZCguLi4pID8NCg0K T24gOC8zLzI2IDEyOjA5IEFNLCBGw6RyYmVyLCBGcmFuei1Kb3NlZiAoU3RNVUspIHdyb3RlOg0K PiBEZWFyIFBvc3RncmVzIENvbW11bml0eSwNCj4gDQo+IGNmLiBodHRwczovL3d3dy5wb3N0Z3Jl c3FsLm9yZy9kb2NzL2N1cnJlbnQvc3FsLXVwZGF0ZS5odG1sIDoNCj4gDQo+IEFzIGZhciBhcyBJ IHVuZGVyc3RhbmQsIEkgY2FuDQo+IA0KPiAqIFVQREFURSBteVRhYmxlIFNFVCBjb2wxID0gdmFs MSwgY29sMiA9IHZhbDIsIC4uLg0KPiAqIFVQREFURSBteVRhYmxlIFNFVCAoY29sMSwgY29sMiwg Li4uKSA9IDxST1ctb3Itc3Vic2VsZWN0Pg0KPiANCj4gQnV0IEkgY2Fubm90LCBhbmQgSSBhbSBt aXNzaW5nIHRoYXQ6DQo+ICogVVBEQVRFIG15VGFibGUgU0VUIChteVRhYmxlLiopID0gPFJPVy1v ci1zdWJzZWxlY3Q+DQo+ICogVVBEQVRFIG15VGFibGUgU0VUIChjb2wxLCBjb2wyLCAuLi4pID0g anNvbl9wb3B1bGF0ZV9yZWNvcmQoTlVMTDo6bXlUYWJsZSwgbXlKc29uKSAgIC0tIHRoaXMgaXMg YSBmdW5jdGlvbiwgbm90IGEgUk9XIGNvbnN0cnVjdCBhbmQgbm90IGEgc3Vic2VsZWN0DQoNCk1h a2UgaXQgYSBzdWJzZWxlY3Q/IE5vdCB0ZXN0ZWQgYnV0Og0KDQpVUERBVEUgbXlUYWJsZSBTRVQg KGNvbDEsIGNvbDIsIC4uLikgPSAoc2VsZWN0ICogZnJvbSBqc29uX3BvcHVsYXRlX3JlY29yZChO VUxMOjpteVRhYmxlLCBteUpzb24pKQ0KDQo+IA0KPiBUaGlzIHdvdWxkIGJlIHVzZWZ1bCBmb3Ig c29tZSBvZiBteSB0cmlnZ2VyIGNvZGUuDQo+IA0KPiANCj4gUmVnYXJkcywNCj4gZmpmMjAwMg0K PiANCj4gDQo+IA0KDQoNCi0tDQpBZHJpYW4gS2xhdmVyDQphZHJpYW4ua2xhdmVyQGFrbGF2ZXIu Y29tDQo=