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 1qHNK3-0002bH-70 for pgsql-general@arkaria.postgresql.org; Thu, 06 Jul 2023 11:38:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qHNK2-0002cY-4f for pgsql-general@arkaria.postgresql.org; Thu, 06 Jul 2023 11:38:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qHNK1-0002cO-Mx for pgsql-general@lists.postgresql.org; Thu, 06 Jul 2023 11:38:53 +0000 Received: from m1550.mail.126.com ([220.181.15.50]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qHNJs-002LUN-2N for pgsql-general@lists.postgresql.org; Thu, 06 Jul 2023 11:38:52 +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=Suweu2NAAA++PxMySCC3atnpo10vZzMiuCZSPiSJLJ0=; b=A xsmtPthfVEGGu4Xoi5hTz5hwt8yZ53+6LnUG9IFVGHflnXMj2zS5AmZw3TnHtDM0 rRi0tnjABvw6HBTXTpW3IxytuyCKIrZ0N9Nba/het6S1dUyWFdfWQxvacLmBIo0w IqfnHJ1PUun2In+fEBAILUEgPSTs3wNX8JJF5Qa9xg= Received: from gzhcoder$126.com ( [222.175.120.219, 211.144.19.63] ) by ajax-webmail-wmsvr50 (Coremail) ; Thu, 6 Jul 2023 19:38:37 +0800 (CST) X-Originating-IP: [222.175.120.219, 211.144.19.63] Date: Thu, 6 Jul 2023 19:38:37 +0800 (CST) From: gzh To: "Pavel Stehule" 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: References: <2f8f581c.67f1.1892a7fba60.Coremail.gzhcoder@126.com> X-NTES-SC: AL_QuyTCvqfvE0q4SCfYOkXk0oXj+Y2WsK2vPgv245ROZ00uCrR6DsjVlRqB0Pr086hDgSMmzO3ThZow/p+cbd4T6O/1L0u2TjWF2OIQNszvtrf Content-Type: multipart/alternative; boundary="----=_Part_109267_1545698841.1688643517079" MIME-Version: 1.0 Message-ID: <15ecd6c2.7480.1892aff3a97.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: MsqowAD3_6u+p6ZkY3Y7AA--.18962W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbiHgGkWWIxqpknRQACsi X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_109267_1545698841.1688643517079 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 VGhhbmsgeW91IHZlcnkgbXVjaCBmb3IgdGFraW5nIHRoZSB0aW1lIHRvIHJlcGx5IHRvIG15IHF1 ZXN0aW9uLiAKVGhlcmUgYXJlIGEgbG90IG9mIFRPX0NIQVIgaW4gbXkgYXBwbGljYXRpb24sIGFu ZCB0aGVyZSBpcyBhIGhpZ2ggY29zdCBvZiBtb2RpZnlpbmcgdGhlIGNvZGUsIAppcyB0aGVyZSBh bm90aGVyIHNvbHV0aW9uIHRvIHNvbHZlIHRoZSBwcm9ibGVtIHdpdGhvdXQgbW9kaWZ5aW5nIHRo ZSBjb2RlPwoKCgoKCgoKQXQgMjAyMy0wNy0wNiAxOToyMToyNCwgIlBhdmVsIFN0ZWh1bGUiIDxw YXZlbC5zdGVodWxlQGdtYWlsLmNvbT4gd3JvdGU6CgpIaQoKCgrEjXQgNi4gNy4gMjAyMyB2IDEx OjE5IG9kZXPDrWxhdGVsIGd6aCA8Z3poY29kZXJAMTI2LmNvbT4gbmFwc2FsOgoKCkhpLCAKCgoK CkkgdXBncmFkZWQgdGhlIHZlcnNpb24gb2YgUG9zdGdyZVNRTCBmcm9tIDEyLjYgdG8gMTIuMTMs IAoKd2hlbiBJIGV4ZWN1dGUgdGhlIHNxbCBiZWxvdyAsIHRoZSB0b19jaGFyIGZ1bmN0aW9uIGNh dXNlZCB0aGUgZm9sbG93aW5nIGVycm9yLgoKCgoKLS0tLS0tLS0tLS0tLS0tU1FMLS0tLS0tLS0t LS0tLS0tLS0tCgpzZWxlY3QgVE9fQ0hBUignMTAwMDAwMCcpOwoKCgoKRVJST1I6ICBmdW5jdGlv biB0b19jaGFyKHVua25vd24pIGlzIG5vdCB1bmlxdWUgYXQgY2hhcmFjdGVyIDgKCkhJTlQ6ICBD b3VsZCBub3QgY2hvb3NlIGEgYmVzdCBjYW5kaWRhdGUgZnVuY3Rpb24uIFlvdSBtaWdodCBuZWVk IHRvIGFkZCBleHBsaWNpdCB0eXBlIGNhc3RzLgoKCgoKVGhlcmUgaXMgbm8gcHJvYmxlbSBiZWZv cmUgdGhlIHVwZ3JhZGUgYW5kIHRvX2NoYXIgZnVuY3Rpb24gY29tZXMgZnJvbSB0aGUgT3JhZmNl IGV4dGVuc2lvbi4KClRoZSBjb25maWd1cmF0aW9uIG9mIHRoZSBvbGQgYW5kIG5ldyBkYXRhYmFz ZXMgaXMgYXMgZm9sbG93cy4KCgoKCkRhdGFiYXNlIHNlcnZlciAob2xkKTogUG9zdGdyZVNRTCAx Mi4277yIb3JhZmNlMy4xM++8iQoKRGF0YWJhc2Ugc2VydmVyIChuZXcpOiBQb3N0Z3JlU1FMIDEy LjEz77yIb3JhZmNlMy4yNO+8iQoKCgoKVGhlIG5ldyBkYXRhYmFzZSBoYXMgc3VjY2Vzc2Z1bGx5 IGluc3RhbGxlZCB0aGUgb3JhZmNlIDMuMjQgZXh0ZW5zaW9uLgoKSXQgZG9lcyBub3Qgb2NjdXIg aW4gIlBvc3RncmVTUUwgMTIuNiBhbmQgb3JhZmNlIDMuMTMiLCAKCmJ1dCBvY2N1cnMgaW4gIlBv c3RncmVTUUwgMTIuMTMgYW5kIG9yYWZjZSAzLjI0IiwgCgpzbyBlaXRoZXIgdGhlIGRpZmZlcmVu Y2UgYmV0d2VlbiAxMi42IGFuZCAxMi4xMyBvciB0aGUgZGlmZmVyZW5jZSBiZXR3ZWVuIG9yYWZj ZSAzLjEzIGFuZCAzLjI0IGlzIHN1c3BpY2lvdXMuCgoKCgpXaGF0IGlzIHRoZSByZWFzb24gZm9y IHRoZSBwcm9ibGVtIGFuZCBob3cgdG8gZml4IHRoZSBlcnJvcj8KCgoKVGhlIG5ldyBvcmFmY2Ug Y29udGFpbnMgdG9fY2hhciBmb3IgbnVtZXJpYyB0eXBlcyBhbmQgdG9fY2hhciBmb3IgdGltZXN0 YW1wLiBPbGQgb3JhZmNlIGhhZCB0b19jaGFyIGZ1bmN0aW9uICh3aXRoIG9uZSBhcmd1bWVudCkg b25seSBmb3IgbnVtZXJpYyB0eXBlcy4KCgpUaGlzIGlzIHRoZSByZWFzb24gd2h5IHRoZSBzeXN0 ZW0gZG9lc24ndCBrbm93IGlmIGEgc3RyaW5nIG9mIHVua25vd24gdHlwZSAocG9zdGdyZXNxbCBz dHJpbmcgbGl0ZXJhbCkgc2hvdWxkIGJlIHByb2Nlc3NlZCBhcyBudW1lcmljIG9yIGFzIGEgdGlt ZXN0YW1wLgoKClRoZSBiZXN0IGZpeCBpcyBzcGVjaWZ5IHVzZWQgdHlwZSBsaWtlCgoKKDIwMjMt MDctMDYgMTM6MTk6MzMpIHBvc3RncmVzPSMgc2VsZWN0IG9yYWNsZS5UT19DSEFSKCcxMDAwMDAw Jzo6aW50KTsK4pSM4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSQCuKUgiB0b19jaGFyIOKU ggrilZ7ilZDilZDilZDilZDilZDilZDilZDilZDilZDilaEK4pSCIDEwMDAwMDAg4pSCCuKUlOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUmAooMSByb3cpCgoKUmVnYXJkcwoKClBhdmVsCgoK CgoKUmVnYXJkcwoKCg== ------=_Part_109267_1545698841.1688643517079 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPlRoYW5rIHlvdSB2ZXJ5 IG11Y2ggZm9yIHRha2luZyB0aGUgdGltZSB0byByZXBseSB0byBteSBxdWVzdGlvbi4mbmJzcDs8 L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5UaGVyZSBhcmUgYSBsb3Qgb2YgVE9fQ0hBUiBp biBteSBhcHBsaWNhdGlvbiwgYW5kIHRoZXJlIGlzIGEgaGlnaCBjb3N0IG9mIG1vZGlmeWluZyB0 aGUgY29kZSwmbmJzcDs8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5pcyB0aGVyZSBhbm90 aGVyIHNvbHV0aW9uIHRvIHNvbHZlIHRoZSBwcm9ibGVtIHdpdGhvdXQgbW9kaWZ5aW5nIHRoZSBj b2RlPzwvZGl2PjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxkaXYgc3R5bGU9InBvc2l0 aW9uOnJlbGF0aXZlO3pvb206MSI+PC9kaXY+PGRpdiBpZD0iZGl2TmV0ZWFzZU1haWxDYXJkIj48 L2Rpdj48cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvcD48cD5BdCAyMDIzLTA3LTA2IDE5OjIx OjI0LCAiUGF2ZWwgU3RlaHVsZSIgJmx0O3BhdmVsLnN0ZWh1bGVAZ21haWwuY29tJmd0OyB3cm90 ZTo8L3A+PGJsb2NrcXVvdGUgaWQ9ImlzUmVwbHlDb250ZW50IiBzdHlsZT0iUEFERElORy1MRUZU OiAxZXg7IE1BUkdJTjogMHB4IDBweCAwcHggMC44ZXg7IEJPUkRFUi1MRUZUOiAjY2NjIDFweCBz b2xpZCI+PGRpdiBkaXI9Imx0ciI+PGRpdj5IaTxicj48L2Rpdj48YnI+PGRpdiBjbGFzcz0iZ21h aWxfcXVvdGUiPjxkaXYgZGlyPSJsdHIiIGNsYXNzPSJnbWFpbF9hdHRyIj7EjXQgNi4gNy4gMjAy MyB2Jm5ic3A7MTE6MTkgb2Rlc8OtbGF0ZWwgZ3poICZsdDs8YSBocmVmPSJtYWlsdG86Z3poY29k ZXJAMTI2LmNvbSI+Z3poY29kZXJAMTI2LmNvbTwvYT4mZ3Q7IG5hcHNhbDo8YnI+PC9kaXY+PGJs b2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0ibWFyZ2luOjBweCAwcHggMHB4IDAu OGV4O2JvcmRlci1sZWZ0OjFweCBzb2xpZCByZ2IoMjA0LDIwNCwyMDQpO3BhZGRpbmctbGVmdDox ZXgiPjxkaXYgc3R5bGU9ImxpbmUtaGVpZ2h0OjEuNztjb2xvcjpyZ2IoMCwwLDApO2ZvbnQtc2l6 ZToxNHB4O2ZvbnQtZmFtaWx5OkFyaWFsIj48cCBzdHlsZT0ibWFyZ2luOjBweCI+SGksJm5ic3A7 PC9wPjxwIHN0eWxlPSJtYXJnaW46MHB4Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46MHB4Ij5J IHVwZ3JhZGVkIHRoZSB2ZXJzaW9uIG9mIFBvc3RncmVTUUwgZnJvbSAxMi42IHRvIDEyLjEzLCZu YnNwOzwvcD48cCBzdHlsZT0ibWFyZ2luOjBweCI+d2hlbiBJIGV4ZWN1dGUgdGhlIHNxbCBiZWxv dyAsIHRoZSB0b19jaGFyIGZ1bmN0aW9uIGNhdXNlZCB0aGUgZm9sbG93aW5nIGVycm9yLjwvcD48 cCBzdHlsZT0ibWFyZ2luOjBweCI+PGJyPjwvcD48cCBzdHlsZT0ibWFyZ2luOjBweCI+LS0tLS0t LS0tLS0tLS0tU1FMLS0tLS0tLS0tLS0tLS0tLS0tPC9wPjxwIHN0eWxlPSJtYXJnaW46MHB4Ij5z ZWxlY3QgVE9fQ0hBUignMTAwMDAwMCcpOzwvcD48cCBzdHlsZT0ibWFyZ2luOjBweCI+PGJyPjwv cD48cCBzdHlsZT0ibWFyZ2luOjBweCI+RVJST1I6Jm5ic3A7IGZ1bmN0aW9uIHRvX2NoYXIodW5r bm93bikgaXMgbm90IHVuaXF1ZSBhdCBjaGFyYWN0ZXIgODwvcD48cCBzdHlsZT0ibWFyZ2luOjBw eCI+SElOVDombmJzcDsgQ291bGQgbm90IGNob29zZSBhIGJlc3QgY2FuZGlkYXRlIGZ1bmN0aW9u LiBZb3UgbWlnaHQgbmVlZCB0byBhZGQgZXhwbGljaXQgdHlwZSBjYXN0cy48L3A+PHAgc3R5bGU9 Im1hcmdpbjowcHgiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjowcHgiPlRoZXJlIGlzIG5vIHBy b2JsZW0gYmVmb3JlIHRoZSB1cGdyYWRlIGFuZCB0b19jaGFyIGZ1bmN0aW9uIGNvbWVzIGZyb20g dGhlIE9yYWZjZSBleHRlbnNpb24uPC9wPjxwIHN0eWxlPSJtYXJnaW46MHB4Ij5UaGUgY29uZmln dXJhdGlvbiBvZiB0aGUgb2xkIGFuZCBuZXcgZGF0YWJhc2VzIGlzIGFzIGZvbGxvd3MuPC9wPjxw IHN0eWxlPSJtYXJnaW46MHB4Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46MHB4Ij5EYXRhYmFz ZSBzZXJ2ZXIgKG9sZCk6IFBvc3RncmVTUUwgMTIuNu+8iG9yYWZjZTMuMTPvvIk8L3A+PHAgc3R5 bGU9Im1hcmdpbjowcHgiPkRhdGFiYXNlIHNlcnZlciAobmV3KTogUG9zdGdyZVNRTCAxMi4xM++8 iG9yYWZjZTMuMjTvvIk8L3A+PHAgc3R5bGU9Im1hcmdpbjowcHgiPjxicj48L3A+PHAgc3R5bGU9 Im1hcmdpbjowcHgiPlRoZSBuZXcgZGF0YWJhc2UgaGFzIHN1Y2Nlc3NmdWxseSBpbnN0YWxsZWQg dGhlIG9yYWZjZSAzLjI0IGV4dGVuc2lvbi48L3A+PHAgc3R5bGU9Im1hcmdpbjowcHgiPkl0IGRv ZXMgbm90IG9jY3VyIGluICJQb3N0Z3JlU1FMIDEyLjYgYW5kIG9yYWZjZSAzLjEzIiwmbmJzcDs8 L3A+PHAgc3R5bGU9Im1hcmdpbjowcHgiPmJ1dCBvY2N1cnMgaW4gIlBvc3RncmVTUUwgMTIuMTMg YW5kIG9yYWZjZSAzLjI0IiwmbmJzcDs8L3A+PHAgc3R5bGU9Im1hcmdpbjowcHgiPnNvIGVpdGhl ciB0aGUgZGlmZmVyZW5jZSBiZXR3ZWVuIDEyLjYgYW5kIDEyLjEzIG9yIHRoZSBkaWZmZXJlbmNl IGJldHdlZW4gb3JhZmNlIDMuMTMgYW5kIDMuMjQgaXMgc3VzcGljaW91cy48L3A+PHAgc3R5bGU9 Im1hcmdpbjowcHgiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjowcHgiPldoYXQgaXMgdGhlIHJl YXNvbiBmb3IgdGhlIHByb2JsZW0gYW5kIGhvdyB0byBmaXggdGhlIGVycm9yPzwvcD48L2Rpdj48 L2Jsb2NrcXVvdGU+PGRpdj48YnI+PC9kaXY+PGRpdj5UaGUgbmV3IG9yYWZjZSBjb250YWlucyB0 b19jaGFyIGZvciBudW1lcmljIHR5cGVzIGFuZCB0b19jaGFyIGZvciB0aW1lc3RhbXAuIE9sZCBv cmFmY2UgaGFkIHRvX2NoYXIgZnVuY3Rpb24gKHdpdGggb25lIGFyZ3VtZW50KSBvbmx5IGZvciBu dW1lcmljIHR5cGVzLjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+VGhpcyBpcyB0aGUgcmVhc29u IHdoeSB0aGUgc3lzdGVtIGRvZXNuJ3Qga25vdyBpZiBhIHN0cmluZyBvZiB1bmtub3duIHR5cGUg KHBvc3RncmVzcWwgc3RyaW5nIGxpdGVyYWwpIHNob3VsZCBiZSBwcm9jZXNzZWQgYXMgbnVtZXJp YyBvciBhcyBhIHRpbWVzdGFtcC48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PlRoZSBiZXN0IGZp eCBpcyBzcGVjaWZ5IHVzZWQgdHlwZSBsaWtlPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj4oPHNw YW4gc3R5bGU9ImZvbnQtZmFtaWx5Om1vbm9zcGFjZSI+MjAyMy0wNy0wNiAxMzoxOTozMykgcG9z dGdyZXM9IyBzZWxlY3Qgb3JhY2xlLlRPX0NIQVIoJzEwMDAwMDAnOjppbnQpOzxicj7ilIzilIDi lIDilIDilIDilIDilIDilIDilIDilIDilJA8YnI+4pSCIHRvX2NoYXIg4pSCPGJyPuKVnuKVkOKV kOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVoTxicj7ilIIgMTAwMDAwMCDilII8YnI+4pSU4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSYPGJyPigxIHJvdyk8L3NwYW4+PC9kaXY+PGRpdj48YnI+ PC9kaXY+PGRpdj5SZWdhcmRzPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5QYXZlbDxicj48L2Rp dj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46MHB4IDBweCAw cHggMC44ZXg7Ym9yZGVyLWxlZnQ6MXB4IHNvbGlkIHJnYigyMDQsMjA0LDIwNCk7cGFkZGluZy1s ZWZ0OjFleCI+PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOnJnYigwLDAsMCk7Zm9u dC1zaXplOjE0cHg7Zm9udC1mYW1pbHk6QXJpYWwiPjxwIHN0eWxlPSJtYXJnaW46MHB4Ij48YnI+ PC9wPjxwIHN0eWxlPSJtYXJnaW46MHB4Ij5SZWdhcmRzPC9wPjxkaXY+PGJyPjwvZGl2PjwvZGl2 PjwvYmxvY2txdW90ZT48L2Rpdj48L2Rpdj4KPC9ibG9ja3F1b3RlPjwvZGl2Pg== ------=_Part_109267_1545698841.1688643517079--