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 1vlrCE-004h3j-1i for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jan 2026 16:18:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlrCB-005OOw-1H for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jan 2026 16:18:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vlrCA-005OOn-22 for pgsql-hackers@lists.postgresql.org; Fri, 30 Jan 2026 16:18:07 +0000 Received: from smtpbgbr1.qq.com ([54.207.19.206]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vlrBx-00000000DrK-46g5 for pgsql-hackers@postgresql.org; Fri, 30 Jan 2026 16:18:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=halodbtech.com; s=wqvr2403; t=1769789847; bh=91sQ3W7DfobJlbKveC8Z/YoQcd/8Jc6YjyGk+0qJhfQ=; h=From:To:Subject:Mime-Version:Date:Message-ID; b=oUT86VEy7nVOh1lwc0VMy0AGP8nRlgxTjMID2s3FWdf9lueRH5mc7K2hYK7HLUth8 CzZtZaw2SCejFKAZFOOOYjfz+XeSvvi0OV5HcfjVVn9NXYNQPtZUyr6CT7pWziBuNx 9nwtByL+z4+aDFdV6X6KjYMX+rNW2mVSs4vga+n8= EX-QQ-RecipientCnt: 5 X-QQ-GoodBg: 2 X-QQ-SSF: 00400000000000F0 X-QQ-FEAT: D4aqtcRDiqSE8ZG9RUj9sSovWVo5u0ua16tXdykBVCI= X-QQ-BUSINESS-ORIGIN: 2 X-QQ-Originating-IP: Do/85lBJRTnyGe8IYZfqBuCorQeiNsly+Puce6gwnAI= X-Originating-IP: 117.147.166.11 X-QQ-STYLE: X-QQ-mid: lv3gz7b-4t1769789842t5a33ca1e From: "=?gb18030?B?emVuZ21hbg==?=" To: "=?gb18030?B?amlhbiBoZQ==?=" Cc: "=?gb18030?B?RGF2aWQgRy4gSm9obnN0b24=?=" , "=?gb18030?B?Q29yZXkgSHVpbmtlcg==?=" , "=?gb18030?B?cGdzcWwtaGFja2Vycw==?=" , "=?gb18030?B?VmlrIEZlYXJpbmc=?=" Subject: Re: implement CAST(expr AS type FORMAT 'template') Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_697CD992_2AAF2EA0_22C9A2C6" Content-Transfer-Encoding: 8Bit Date: Sat, 31 Jan 2026 00:17:22 +0800 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x References: <4c358bf8-87e8-4760-83d5-a6f9fcd88907@postgresfriends.org> <1b702de4-86b0-4144-a2d0-38266296894f@postgresfriends.org> <82b4223e-84d4-432d-8167-dd698ce489f5@postgresfriends.org> In-Reply-To: X-QQ-ReplyHash: 62311001 X-BIZMAIL-ID: 5500593234773852304 X-Address-Ticket:version=;type=;ticket_id=;id_list=;display_name=;session_id=; X-QQ-SENDSIZE: 520 Received: from qq.com (unknown [127.0.0.1]) by smtp.qq.com (ESMTP) with SMTP id ; Sat, 31 Jan 2026 00:17:23 +0800 (CST) Feedback-ID: lv:halodbtech.com:qybglogicsvrsz:qybglogicsvrsz3b-0 X-QQ-XMAILINFO: NWth7vBa++Gdh1GQ7KqL3S7Np7vxZclnYNBE0xO3k+iGp954mb1KCcBD ome1ko25679KQ48mYFeKOA9QeprlFW7Q3jsB26h04diSo176Md1iLg2dstIbpqMJgBoq8ab s8PHtaWiH3FoAI73WmGQKqm9Yjzo2brco4xQ+AY65JOhWLXOMN14ecKqzrqZkKZi+PiycYV F4kmY9IOL/YmY9OV9TefXLBH40m+5YaKKgk2WiAUto3oUBkI+Xtpe908lUNJOip9BluY6TV XxhmuxmcBvc+G1jf1+IGPE+6owBTV35mMMVIvFtJS8lw2vJYl8N7/k8NZo6Y9LlaBmNzyR6 W+k913TQougbvfGu/fRpQS1pLVqycz2uVar3AIR8c3LbuTW6smeJ9Xn3QIaRNIifOtSIiqv 3C7c08iW5ZqSYKCjW1poSJYjkUtjsA9+U2UzVOiUwfl9vvhIWP53S1vvbP7N9bqFQjhxOso 8gmWDbpZEThFZ6rbhXMMwg7onbsltY4qbpOmGGf9Q6eXC/+cT8H5ZzvW+g0krlm55z06QnE OqwmSCexEzEflE5EF6osYNQHpjww+dyczIZtNiAVZ+r8Xc6YozgdxY8SNzInCXbCgfIlQbu FLa4g8d4gxRQic9UnAA47uJrdBMM8atJLqIFGSb3bCDhS6jabXBHRCzIbH2Ev3i+ePT9Ejx /6VtfK1BelefO+EVzSe1F/PvoCRhjlNKwKr4833nZyWIkQLH+coyvJhd6Dq+HFcMFmTdfCq ibl0B0kOVnZ9JJSI6CNvqg0zZVsD7LzZy3TIZGbW0C/16CreYvKU3HAmqjLmKusXgkuU7/c 564FmW4fjFOU7bDqeM1r/NpBSZjQRucT8zIhVUzcflMPNl8SQ47Djf2ScOPOlGgpAENMfi6 sEdUPaO4rqSESDA278+NGYI4V5CvRC8IJv69bz8/Hoc3dlEvEByP5t3bXKAzI+6YTf3Ecxx bBxmcVF3nldPu9O1HKcZ7Y6erfD9Qum5us/W5zDOh/Sb9aJpjUd8Dxukca10v4Y87Rk7SH5 m+o+N/e/vH0feqhAqokOjHQZRKuiE= X-QQ-XMRINFO: OD9hHCdaPRBwH5bRRRw8tsiH4UAatJqXfg== X-QQ-RECHKSPAM: 0 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. ------=_NextPart_697CD992_2AAF2EA0_22C9A2C6 Content-Type: text/plain; charset="gb18030" Content-Transfer-Encoding: base64 PiBQbGVhc2UgY2hlY2sgdGhlIGF0dGFjaGVkIG5ldyB2ZXJzaW9uLg0KPiANCj4gSaGvdmUg aW50ZWdyYXRlZCB0aGUgQ0FTVCBGT1JNQVQgbG9naWMgcmlnaHQgaW50byBjb2VyY2VfdG9f dGFyZ2V0X3R5cGUgYW5kDQo+IGNvZXJjZV90eXBlLCBzZWUgc3RhdGljIGZ1bmN0aW9uIGNv ZXJjZV90eXBlX3dpdGhfZm9ybWF0LiBpbg0KPiBjb2VyY2VfdHlwZV93aXRoX2Zvcm1hdCwg d2UgZmlyc3QgZmlyc3QgZG8gc291cmNlIHR5cGUsIHRhcmdldCB0eXBlLCBmb3JtYXQNCj4g ZXhwcmVzc2lvbiBjaGVjaywgdmFsaWRhdGlvbiwgaWYgZXZlcnl0aGluZyBpcyBvayB0aGVu LCBjb25zdHJ1Y3QgYSBGdW5jQ2FsbA0KPiBub2RlIGFuZCBsZXQgUGFyc2VGdW5jT3JDb2x1 bW4gZG8gYWxsIHRoZSByZW1haW5pbmcgam9iLCB3aXRoIHRoYXQgbm93IG92ZXJhbGwNCj4g dGhlIHBhdGNoIGxvb2tzIG1vcmUgbmVhdC4NCg0KSGksDQoNClRoaXMgcGF0Y2ggbG9va3Mg Z3JlYXQsIGFuZCB0aGUgdGVzdHMgcnVuIHdlbGwuIEkgZm91bmQgYSBmZXcgbWlub3IgZGV0 YWlscywNCnRoYXQgeW91IG1pZ2h0IGNvbnNpZGVyIGZpeGluZzoNCg0KVHlwb3MNCi0gcGFy c2VfZXhwci5jOjI3NDU6ICJmb3JtbWF0dGVkIiCh+iAiZm9ybWF0dGVkIg0KLSBwYXJzZV9j b2VyY2UuYzoxNTY6ICJDb2NlcmNlIiCh+iAiQ29lcmNlIg0KDQpJbiBgY29lcmNlX3R5cGVf d2l0aF9mb3JtYXQoKWAgKHBhcnNlX2NvZXJjZS5jKToNCg0KMS4gVGhlIGNoZWNrIGBpZiAo Zm10Y2F0ZWdvcnkgIT0gVFlQQ0FURUdPUllfU1RSSU5HICYmIGZtdGNhdGVnb3J5ICE9IFRZ UENBVEVHT1JZX1VOS05PV04pYA0KY291bGQgYmUgbW92ZWQgZWFybGllci4gSXQgZG9lc24n dCBkZXBlbmQgb24gYW55IG90aGVyDQpjYWxjdWxhdGlvbnMsIHNvIGZhaWxpbmcgZmFzdCBo ZXJlIHdvdWxkIGF2b2lkIHVubmVjZXNzYXJ5IHdvcmsuDQoNCjIuIGNvbnNpZGVyIHVzaW5n YCBsaXN0X21ha2UyKG5vZGUsIGZvcm1hdClgIGluc3RlYWQgb2YgYGxpc3RfbWFrZTEoKSAr IGxhcHBlbmQoKWAuDQoNCi0tDQpSZWdhcmRzLA0KTWFuIFplbmc= ------=_NextPart_697CD992_2AAF2EA0_22C9A2C6 Content-Type: application/octet-stream; charset="gb18030"; name="cleanup_suggestions.txt" Content-Disposition: attachment; filename="cleanup_suggestions.txt" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9jb2VyY2UuYyBiL3NyYy9i YWNrZW5kL3BhcnNlci9wYXJzZV9jb2VyY2UuYwppbmRleCBiZmFhYzQyMjllYS4uMmUwYjky Nzg1MWMgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9jb2VyY2UuYwor KysgYi9zcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfY29lcmNlLmMKQEAgLTE1Myw3ICsxNTMs NyBAQCBjb2VyY2VfdG9fdGFyZ2V0X3R5cGVfZXh0ZW5kZWQoUGFyc2VTdGF0ZSAqcHN0YXRl LCBOb2RlICpleHByLCBPaWQgZXhwcnR5cGUsCiAgLyoKICAgKiBjb2VyY2VfdHlwZV93aXRo X2Zvcm1hdCgpCiAgICoKLSAgKiBDb2NlcmNlIHRoZSBDQVNUKGV4cHIgQVMgdHlwZSBGT1JN QVQgJ2ZtdCcpIGNvbnN0cnVjdCB0byB0aGUgdGFyZ2V0IHR5cGUuCisgICogQ29lcmNlIHRo ZSBDQVNUKGV4cHIgQVMgdHlwZSBGT1JNQVQgJ2ZtdCcpIGNvbnN0cnVjdCB0byB0aGUgdGFy Z2V0IHR5cGUuCiAgICoKICAgKiBUaGlzIGlzIGEgc3Vicm91dGluZSBvZiBjb2VyY2VfdHlw ZV9leHRlbmRlZC4gVGhlIGNhbGxlciBtdXN0IGVuc3VyZSB0aGF0CiAgICogdGhlIGNvZXJj aW9uIGlzIHBvc3NpYmxlIHZpYSBjYW5fY29lcmNlX3R5cGUuCkBAIC0xODcsNiArMTg3LDEy IEBAIGNvZXJjZV90eXBlX3dpdGhfZm9ybWF0KFBhcnNlU3RhdGUgKnBzdGF0ZSwgTm9kZSAq bm9kZSwgTm9kZSAqZm10LAogCXRfdHlwY2F0ZWdvcnkgPSBUeXBlQ2F0ZWdvcnkodGFyZ2V0 QmFzZVR5cGVJZCk7CiAJZm10Y2F0ZWdvcnkgPSBUeXBlQ2F0ZWdvcnkoZm9ybWF0QmFzZVR5 cGVJZCk7CiAKKwlpZiAoZm10Y2F0ZWdvcnkgIT0gVFlQQ0FURUdPUllfU1RSSU5HICYmIGZt dGNhdGVnb3J5ICE9IFRZUENBVEVHT1JZX1VOS05PV04pCisJCWVyZXBvcnQoRVJST1IsCisJ CQkJZXJyY29kZShFUlJDT0RFX0NBTk5PVF9DT0VSQ0UpLAorCQkJCWVycm1zZygiQ0FTVCBG T1JNQVQgZXhwcmVzc2lvbiBpcyBub3Qgb2YgdHlwZSB0ZXh0IiksCisJCQkJcGFyc2VyX2Vy cnBvc2l0aW9uKHBzdGF0ZSwgZXhwckxvY2F0aW9uKGZtdCkpKTsKKwogCS8qCiAJICogU2lu Y2UgdGhlIGNhbGxlciAoY29lcmNlX3R5cGVfZXh0ZW5kZWQpIGRvZXMgbm90IGhhbmRsZSAn VW5rbm93bicKIAkgKiBjb25zdGFudHMsIHdlIG11c3QgZXhwbGljaXRseSBjb2VyY2UgdGhl bSB0byBURVhUIGluIHRoZSBzb3VyY2UKQEAgLTI1NCwxMiArMjYwLDYgQEAgY29lcmNlX3R5 cGVfd2l0aF9mb3JtYXQoUGFyc2VTdGF0ZSAqcHN0YXRlLCBOb2RlICpub2RlLCBOb2RlICpm bXQsCiAJCQkJZXJyaGludCgiT25seSB0aW1lc3RhbXB0eiwgdGV4dCwgbnVtZXJpYyBhbmQg ZGF0ZSBkYXRhIHR5cGUgYXJlIHN1cHBvcnRlZCBmb3IgZm9ybWF0dGVkIHR5cGUgY2FzdGlu ZyIpLAogCQkJCXBhcnNlcl9jb2VyY2lvbl9lcnJwb3NpdGlvbihwc3RhdGUsIGxvY2F0aW9u LCBub2RlKSk7CiAKLQlpZiAoZm10Y2F0ZWdvcnkgIT0gVFlQQ0FURUdPUllfU1RSSU5HICYm IGZtdGNhdGVnb3J5ICE9IFRZUENBVEVHT1JZX1VOS05PV04pCi0JCWVyZXBvcnQoRVJST1Is Ci0JCQkJZXJyY29kZShFUlJDT0RFX0NBTk5PVF9DT0VSQ0UpLAotCQkJCWVycm1zZygiQ0FT VCBGT1JNQVQgZXhwcmVzc2lvbiBpcyBub3Qgb2YgdHlwZSB0ZXh0IiksCi0JCQkJcGFyc2Vy X2VycnBvc2l0aW9uKHBzdGF0ZSwgZXhwckxvY2F0aW9uKGZtdCkpKTsKLQogCS8qCiAJICog SW50ZXJuYWxseSwgQ0FTVCBGT1JNQVQgZGVsZWdhdGVzIHRvIGZ1bmN0aW9ucyAoZS5nLiwg dG9fY2hhciwgdG9fZGF0ZSkKIAkgKiB3aGVyZSB0aGUgZm9ybWF0IHN0cmluZyBwYXJhbWV0 ZXIgaXMgdHlwZWQgYXMgVEVYVC4gQ29uc2VxdWVudGx5LCB0aGUKQEAgLTI5Myw4ICsyOTMs NyBAQCBjb2VyY2VfdHlwZV93aXRoX2Zvcm1hdChQYXJzZVN0YXRlICpwc3RhdGUsIE5vZGUg Km5vZGUsIE5vZGUgKmZtdCwKIAkJZWxvZyhFUlJPUiwgImZhaWxlZCB0byBmaW5kIGNvbnZl cnNpb24gZnVuY3Rpb24gZnJvbSAlcyB0byAlcyB3aGlsZSB1c2luZyBhIGZvcm1hdCB0ZW1w bGF0ZSIsCiAJCQkgZm9ybWF0X3R5cGVfYmUoaW5wdXRUeXBlSWQpLCBmb3JtYXRfdHlwZV9i ZSh0YXJnZXRUeXBlSWQpKTsKIAotCWFyZ3MgPSBsaXN0X21ha2UxKG5vZGUpOwotCWFyZ3Mg PSBsYXBwZW5kKGFyZ3MsIGZvcm1hdCk7CisJYXJncyA9IGxpc3RfbWFrZTIobm9kZSwgZm9y bWF0KTsKIAlmbiA9IG1ha2VGdW5jQ2FsbChmdW5jbmFtZSwgYXJncywKIAkJCQkJICBDT0VS Q0VfU1FMX1NZTlRBWCwKIAkJCQkJICAtMSk7CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC9w YXJzZXIvcGFyc2VfZXhwci5jIGIvc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX2V4cHIuYwpp bmRleCBkMTk2MDc5OWVlNS4uYmZmYWRkYzkyMGQgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5k L3BhcnNlci9wYXJzZV9leHByLmMKKysrIGIvc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX2V4 cHIuYwpAQCAtMjc0Miw3ICsyNzQyLDcgQEAgdHJhbnNmb3JtVHlwZUNhc3QoUGFyc2VTdGF0 ZSAqcHN0YXRlLCBUeXBlQ2FzdCAqdGMpCiAJCWlmICh0Yy0+Zm9ybWF0KQogCQkJZXJlcG9y dChFUlJPUiwKIAkJCQkJZXJyY29kZShFUlJDT0RFX0NBTk5PVF9DT0VSQ0UpLAotCQkJCQll cnJtc2coImZvcm1tYXR0ZWQgdHlwZSBjYXN0IGlzIG5vdCBzdXBwb3J0ZWQgZm9yIGFycmF5 IHR5cGUiKSwKKwkJCQkJZXJybXNnKCJmb3JtYXR0ZWQgdHlwZSBjYXN0IGlzIG5vdCBzdXBw b3J0ZWQgZm9yIGFycmF5IHR5cGUiKSwKIAkJCQkJcGFyc2VyX2NvZXJjaW9uX2VycnBvc2l0 aW9uKHBzdGF0ZSwgZXhwckxvY2F0aW9uKGFyZyksIGFyZykpOwogCiAJCS8qCmRpZmYgLS1n aXQgYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL21pc2Mub3V0IGIvc3JjL3Rlc3QvcmVn cmVzcy9leHBlY3RlZC9taXNjLm91dAppbmRleCA0YWVkN2U4YTQ5OC4uMTgwNGVjN2RlMzEg MTAwNjQ0Ci0tLSBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvbWlzYy5vdXQKKysrIGIv c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9taXNjLm91dApAQCAtNDU4LDcgKzQ1OCw3IEBA IExJTkUgMTogc2VsZWN0IGNhc3QoJy0zNCwzMzgsNDkyJyBhcyBiaWdpbnQgZm9ybWF0ICc5 OUc5OTlHOTk5Jyk7CiAgICAgICAgICAgICAgICBeCiBISU5UOiAgT25seSB0aW1lc3RhbXB0 eiwgdGV4dCwgbnVtZXJpYyBhbmQgZGF0ZSBkYXRhIHR5cGUgYXJlIHN1cHBvcnRlZCBmb3Ig Zm9ybWF0dGVkIHR5cGUgY2FzdGluZwogc2VsZWN0IGNhc3QoYXJyYXlbMV0gYXMgdGV4dCBm b3JtYXQgJ1lZWVknKTsKLUVSUk9SOiAgZm9ybW1hdHRlZCB0eXBlIGNhc3QgaXMgbm90IHN1 cHBvcnRlZCBmb3IgYXJyYXkgdHlwZQorRVJST1I6ICBmb3JtYXR0ZWQgdHlwZSBjYXN0IGlz IG5vdCBzdXBwb3J0ZWQgZm9yIGFycmF5IHR5cGUKIExJTkUgMTogc2VsZWN0IGNhc3QoYXJy YXlbMV0gYXMgdGV4dCBmb3JtYXQgJ1lZWVknKTsKICAgICAgICAgICAgICAgICAgICAgXgog c2VsZWN0IGNhc3QoJzEnIGFzIHRpbWVzdGFtcFtdIGZvcm1hdCAnWVlZWS1NTS1ERCcpOwo= ------=_NextPart_697CD992_2AAF2EA0_22C9A2C6--