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 1qHPmL-0001We-LC for pgsql-general@arkaria.postgresql.org; Thu, 06 Jul 2023 14:16:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qHPmK-0004oc-Ia for pgsql-general@arkaria.postgresql.org; Thu, 06 Jul 2023 14:16:16 +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 1qHPmK-0004oT-8A for pgsql-general@lists.postgresql.org; Thu, 06 Jul 2023 14:16:16 +0000 Received: from m1524.mail.126.com ([220.181.15.24]) by magus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qHPmF-002YOY-3q for pgsql-general@lists.postgresql.org; Thu, 06 Jul 2023 14:16:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:Subject:Content-Type:MIME-Version: Message-ID; bh=G6D9pV7XXFlkjmomWkkrPYWawUTiIU9BRNNXU2Sa3sU=; b=Z JSCIEWrOc9APX2m+tNS9SerO6ogVrKcW/dkhVHbtnvS+W8DP4WeNRvIYm5R2dj1n MxEMSUcSJMm0OKRXWJSQND8jD4xwQ1nflietoG8pD92XVLtMPDwTWrjfvlg6HT8q 5bthbZYS5gx7o7mDILPdIPbjwpwZjut6SzGkXcUmr0= Received: from gzhcoder$126.com ( [119.163.77.89] ) by ajax-webmail-wmsvr24 (Coremail) ; Thu, 6 Jul 2023 22:15:54 +0800 (CST) X-Originating-IP: [119.163.77.89] Date: Thu, 6 Jul 2023 22:15:54 +0800 (CST) From: gzh To: "Erik Wienhold" Cc: pgsql-general@lists.postgresql.org Subject: Re: function to_char(unknown) is not unique at character 8 X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.14 build 20230109(dcb5de15) Copyright (c) 2002-2023 www.mailtech.cn 126com In-Reply-To: <269723997.937486.1688643409072@office.mailbox.org> References: <2f8f581c.67f1.1892a7fba60.Coremail.gzhcoder@126.com> <269723997.937486.1688643409072@office.mailbox.org> X-NTES-SC: AL_QuyTCvqevUEu4iefYukWnEgXj+c7Xsu4u/0v34FSNps0kSnn3QsQUFJcN2r18MidDgSBnTWXbAlA2/xaQ5FJcrAnEW+L6nk/IDUi5mL9SYG7 Content-Type: multipart/alternative; boundary="----=_Part_116304_1283537083.1688652954780" MIME-Version: 1.0 Message-ID: <7844e14c.7bb8.1892b8f3c9c.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: GMqowAAXL8+bzKZkJRs6AA--.64043W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbi3BukWVpEFmFqzAAAs1 X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_116304_1283537083.1688652954780 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 VGhhbmsgeW91IHZlcnkgbXVjaCBmb3IgdGFraW5nIHRoZSB0aW1lIHRvIHJlcGx5IHRvIG15IHF1 ZXN0aW9uLiAKSSBhZGRlZCBvcmFjbGUgdG8gc2VhcmNoX3BhdGgsIGJ1dCBpdCBkaWRuJ3Qgd29y ay4KCgpwb3N0Z3Jlcz0jIHNob3cgc2VhcmNoX3BhdGg7CiAgICAgICAgICAgICBzZWFyY2hfcGF0 aAotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiAiJHVzZXIiLCBwdWJsaWMs IG9yYWNsZSwgcGdfY2F0YWxvZwoKCgoKCgoKCgoKCgoKCgoKCgoKQXQgMjAyMy0wNy0wNiAxOToz Njo0OSwgIkVyaWsgV2llbmhvbGQiIDxld2llQGV3aWUubmFtZT4gd3JvdGU6Cj4+IE9uIDA2LzA3 LzIwMjMgMTE6MTkgQ0VTVCBnemggPGd6aGNvZGVyQDEyNi5jb20+IHdyb3RlOgo+Pgo+PiBJIHVw Z3JhZGVkIHRoZSB2ZXJzaW9uIG9mIFBvc3RncmVTUUwgZnJvbSAxMi42IHRvIDEyLjEzLAo+PiB3 aGVuIEkgZXhlY3V0ZSB0aGUgc3FsIGJlbG93ICwgdGhlIHRvX2NoYXIgZnVuY3Rpb24gY2F1c2Vk IHRoZSBmb2xsb3dpbmcgZXJyb3IuCj4+Cj4+IC0tLS0tLS0tLS0tLS0tLVNRTC0tLS0tLS0tLS0t LS0tLS0tLQo+PiBzZWxlY3QgVE9fQ0hBUignMTAwMDAwMCcpOwo+Pgo+PiBFUlJPUjogZnVuY3Rp b24gdG9fY2hhcih1bmtub3duKSBpcyBub3QgdW5pcXVlIGF0IGNoYXJhY3RlciA4Cj4+IEhJTlQ6 IENvdWxkIG5vdCBjaG9vc2UgYSBiZXN0IGNhbmRpZGF0ZSBmdW5jdGlvbi4gWW91IG1pZ2h0IG5l ZWQgdG8gYWRkIGV4cGxpY2l0IHR5cGUgY2FzdHMuCj4+Cj4+IFRoZXJlIGlzIG5vIHByb2JsZW0g YmVmb3JlIHRoZSB1cGdyYWRlIGFuZCB0b19jaGFyIGZ1bmN0aW9uIGNvbWVzIGZyb20gdGhlCj4+ IE9yYWZjZSBleHRlbnNpb24uCj4+IFRoZSBjb25maWd1cmF0aW9uIG9mIHRoZSBvbGQgYW5kIG5l dyBkYXRhYmFzZXMgaXMgYXMgZm9sbG93cy4KPj4KPj4gRGF0YWJhc2Ugc2VydmVyIChvbGQpOiBQ b3N0Z3JlU1FMIDEyLjajqG9yYWZjZTMuMTOjqQo+PiBEYXRhYmFzZSBzZXJ2ZXIgKG5ldyk6IFBv c3RncmVTUUwgMTIuMTOjqG9yYWZjZTMuMjSjqQo+Pgo+PiBUaGUgbmV3IGRhdGFiYXNlIGhhcyBz dWNjZXNzZnVsbHkgaW5zdGFsbGVkIHRoZSBvcmFmY2UgMy4yNCBleHRlbnNpb24uCj4+IEl0IGRv ZXMgbm90IG9jY3VyIGluICJQb3N0Z3JlU1FMIDEyLjYgYW5kIG9yYWZjZSAzLjEzIiwKPj4gYnV0 IG9jY3VycyBpbiAiUG9zdGdyZVNRTCAxMi4xMyBhbmQgb3JhZmNlIDMuMjQiLAo+PiBzbyBlaXRo ZXIgdGhlIGRpZmZlcmVuY2UgYmV0d2VlbiAxMi42IGFuZCAxMi4xMyBvciB0aGUgZGlmZmVyZW5j ZSBiZXR3ZWVuCj4+IG9yYWZjZSAzLjEzIGFuZCAzLjI0IGlzIHN1c3BpY2lvdXMuCj4+Cj4+IFdo YXQgaXMgdGhlIHJlYXNvbiBmb3IgdGhlIHByb2JsZW0gYW5kIGhvdyB0byBmaXggdGhlIGVycm9y Pwo+Cj5UaGlzIHJpbmdzIGEgYmVsbDoKPgo+aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVz c2FnZS1pZC8xNTk3ODc1ODA2LjYwNjM5Mi4xNjgxOTE1ODkzNzcxJTQwb2ZmaWNlLm1haWxib3gu b3JnCj4KPkVpdGhlciBxdWFsaWZ5IGZ1bmN0aW9ucyB3aXRoIG5hbWVzcGFjZSBvcmFjbGUsIGUu Zy4gb3JhY2xlLnRvX2NoYXIoJzEwMDAwMDAnKSwKPm9yIHBsYWNlIG9yYWNsZSBvbiB0aGUgc2Vh cmNoIHBhdGguCj4KPi0tCj5FcmlrCg== ------=_Part_116304_1283537083.1688652954780 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPlRoYW5rIHlvdSB2ZXJ5 IG11Y2ggZm9yIHRha2luZyB0aGUgdGltZSB0byByZXBseSB0byBteSBxdWVzdGlvbi4mbmJzcDs8 L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5JIGFkZGVkIG9yYWNsZSB0byBzZWFyY2hfcGF0 aCwgYnV0IGl0IGRpZG4ndCB3b3JrLjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPjxicj48 L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5wb3N0 Z3Jlcz0jIHNob3cgc2VhcmNoX3BhdGg7PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+Jm5i c3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7c2VhcmNoX3BhdGg8 L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij4tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+Jm5ic3A7IiR1c2VyIiwgcHVi bGljLCBvcmFjbGUsIHBnX2NhdGFsb2c8L2Rpdj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7 Ij48YnI+PC9kaXY+PHAgc3R5bGU9Im1hcmdpbjogMDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdp bjogMDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPjxicj48L3A+PHAgc3R5bGU9Im1h cmdpbjogMDsiPjxicj48L3A+PGRpdiBzdHlsZT0icG9zaXRpb246cmVsYXRpdmU7em9vbToxIj48 L2Rpdj48ZGl2IGlkPSJkaXZOZXRlYXNlTWFpbENhcmQiPjwvZGl2PjxwIHN0eWxlPSJtYXJnaW46 IDA7Ij48YnI+PC9wPjxwcmU+PGJyPkF0IDIwMjMtMDctMDYgMTk6MzY6NDksICJFcmlrIFdpZW5o b2xkIiAmbHQ7ZXdpZUBld2llLm5hbWUmZ3Q7IHdyb3RlOgomZ3Q7Jmd0OyBPbiAwNi8wNy8yMDIz IDExOjE5IENFU1QgZ3poICZsdDtnemhjb2RlckAxMjYuY29tJmd0OyB3cm90ZToKJmd0OyZndDsK Jmd0OyZndDsgSSB1cGdyYWRlZCB0aGUgdmVyc2lvbiBvZiBQb3N0Z3JlU1FMIGZyb20gMTIuNiB0 byAxMi4xMywKJmd0OyZndDsgd2hlbiBJIGV4ZWN1dGUgdGhlIHNxbCBiZWxvdyAsIHRoZSB0b19j aGFyIGZ1bmN0aW9uIGNhdXNlZCB0aGUgZm9sbG93aW5nIGVycm9yLgomZ3Q7Jmd0OwomZ3Q7Jmd0 OyAtLS0tLS0tLS0tLS0tLS1TUUwtLS0tLS0tLS0tLS0tLS0tLS0KJmd0OyZndDsgc2VsZWN0IFRP X0NIQVIoJzEwMDAwMDAnKTsKJmd0OyZndDsKJmd0OyZndDsgRVJST1I6IGZ1bmN0aW9uIHRvX2No YXIodW5rbm93bikgaXMgbm90IHVuaXF1ZSBhdCBjaGFyYWN0ZXIgOAomZ3Q7Jmd0OyBISU5UOiBD b3VsZCBub3QgY2hvb3NlIGEgYmVzdCBjYW5kaWRhdGUgZnVuY3Rpb24uIFlvdSBtaWdodCBuZWVk IHRvIGFkZCBleHBsaWNpdCB0eXBlIGNhc3RzLgomZ3Q7Jmd0OwomZ3Q7Jmd0OyBUaGVyZSBpcyBu byBwcm9ibGVtIGJlZm9yZSB0aGUgdXBncmFkZSBhbmQgdG9fY2hhciBmdW5jdGlvbiBjb21lcyBm cm9tIHRoZQomZ3Q7Jmd0OyBPcmFmY2UgZXh0ZW5zaW9uLgomZ3Q7Jmd0OyBUaGUgY29uZmlndXJh dGlvbiBvZiB0aGUgb2xkIGFuZCBuZXcgZGF0YWJhc2VzIGlzIGFzIGZvbGxvd3MuCiZndDsmZ3Q7 CiZndDsmZ3Q7IERhdGFiYXNlIHNlcnZlciAob2xkKTogUG9zdGdyZVNRTCAxMi42o6hvcmFmY2Uz LjEzo6kKJmd0OyZndDsgRGF0YWJhc2Ugc2VydmVyIChuZXcpOiBQb3N0Z3JlU1FMIDEyLjEzo6hv cmFmY2UzLjI0o6kKJmd0OyZndDsKJmd0OyZndDsgVGhlIG5ldyBkYXRhYmFzZSBoYXMgc3VjY2Vz c2Z1bGx5IGluc3RhbGxlZCB0aGUgb3JhZmNlIDMuMjQgZXh0ZW5zaW9uLgomZ3Q7Jmd0OyBJdCBk b2VzIG5vdCBvY2N1ciBpbiAiUG9zdGdyZVNRTCAxMi42IGFuZCBvcmFmY2UgMy4xMyIsCiZndDsm Z3Q7IGJ1dCBvY2N1cnMgaW4gIlBvc3RncmVTUUwgMTIuMTMgYW5kIG9yYWZjZSAzLjI0IiwKJmd0 OyZndDsgc28gZWl0aGVyIHRoZSBkaWZmZXJlbmNlIGJldHdlZW4gMTIuNiBhbmQgMTIuMTMgb3Ig dGhlIGRpZmZlcmVuY2UgYmV0d2VlbgomZ3Q7Jmd0OyBvcmFmY2UgMy4xMyBhbmQgMy4yNCBpcyBz dXNwaWNpb3VzLgomZ3Q7Jmd0OwomZ3Q7Jmd0OyBXaGF0IGlzIHRoZSByZWFzb24gZm9yIHRoZSBw cm9ibGVtIGFuZCBob3cgdG8gZml4IHRoZSBlcnJvcj8KJmd0OwomZ3Q7VGhpcyByaW5ncyBhIGJl bGw6CiZndDsKJmd0O2h0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQvMTU5Nzg3 NTgwNi42MDYzOTIuMTY4MTkxNTg5Mzc3MSU0MG9mZmljZS5tYWlsYm94Lm9yZwomZ3Q7CiZndDtF aXRoZXIgcXVhbGlmeSBmdW5jdGlvbnMgd2l0aCBuYW1lc3BhY2Ugb3JhY2xlLCBlLmcuIG9yYWNs ZS50b19jaGFyKCcxMDAwMDAwJyksCiZndDtvciBwbGFjZSBvcmFjbGUgb24gdGhlIHNlYXJjaCBw YXRoLgomZ3Q7CiZndDstLQomZ3Q7RXJpawo8L3ByZT48L2Rpdj4= ------=_Part_116304_1283537083.1688652954780--