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 1qHL9J-0004ws-9E for pgsql-general@arkaria.postgresql.org; Thu, 06 Jul 2023 09:19:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qHL9H-0004m3-Df for pgsql-general@arkaria.postgresql.org; Thu, 06 Jul 2023 09:19:39 +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 1qHL9G-0004lu-Dl for pgsql-general@lists.postgresql.org; Thu, 06 Jul 2023 09:19:39 +0000 Received: from m1564.mail.126.com ([220.181.15.64]) by magus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qHL9B-002VX8-JP for pgsql-general@lists.postgresql.org; Thu, 06 Jul 2023 09:19:37 +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=cN+OIh1pxurGWjYbTbKnRXY5fijRi2qb/1S5Lzbxnr4=; b=H 3zuiTWDesUDD5KEJWelDkYZkyuASkHA0wEaz1K0MKkv2zdddDgUaiH/Slvdwk41V d2KNYXubeH//eAQlLvHJrBn9vAhyQktU7jDYdQvKAChgH91f0ISXBpQoIpcWoX/i UN3/fmIjiOLdW3tmf2V08F1JfloJOpzePDMGvYajY0= Received: from gzhcoder$126.com ( [211.144.19.63] ) by ajax-webmail-wmsvr64 (Coremail) ; Thu, 6 Jul 2023 17:19:21 +0800 (CST) X-Originating-IP: [211.144.19.63] Date: Thu, 6 Jul 2023 17:19:21 +0800 (CST) From: gzh To: pgsql-general@lists.postgresql.org Subject: 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 X-NTES-SC: AL_QuyTCvqYukkt5yGQZOkXk0oXj+Y2WsK2vPgv245ROZ00pirt2S4fWFp4JlH68s6DMAGslT24fSVzyudeRIheWI7n/tevdQSt89uiY0wyEec3 Content-Type: multipart/alternative; boundary="----=_Part_97153_2017448864.1688635161184" MIME-Version: 1.0 Message-ID: <2f8f581c.67f1.1892a7fba60.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: QMqowAC3fkQZh6ZkwIU5AA--.28030W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbi5hGkWWIxlxKiIgACse X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_97153_2017448864.1688635161184 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 SGksIAoKCgoKSSB1cGdyYWRlZCB0aGUgdmVyc2lvbiBvZiBQb3N0Z3JlU1FMIGZyb20gMTIuNiB0 byAxMi4xMywgCgp3aGVuIEkgZXhlY3V0ZSB0aGUgc3FsIGJlbG93ICwgdGhlIHRvX2NoYXIgZnVu Y3Rpb24gY2F1c2VkIHRoZSBmb2xsb3dpbmcgZXJyb3IuCgoKCgotLS0tLS0tLS0tLS0tLS1TUUwt LS0tLS0tLS0tLS0tLS0tLS0KCnNlbGVjdCBUT19DSEFSKCcxMDAwMDAwJyk7CgoKCgpFUlJPUjog IGZ1bmN0aW9uIHRvX2NoYXIodW5rbm93bikgaXMgbm90IHVuaXF1ZSBhdCBjaGFyYWN0ZXIgOAoK SElOVDogIENvdWxkIG5vdCBjaG9vc2UgYSBiZXN0IGNhbmRpZGF0ZSBmdW5jdGlvbi4gWW91IG1p Z2h0IG5lZWQgdG8gYWRkIGV4cGxpY2l0IHR5cGUgY2FzdHMuCgoKCgpUaGVyZSBpcyBubyBwcm9i bGVtIGJlZm9yZSB0aGUgdXBncmFkZSBhbmQgdG9fY2hhciBmdW5jdGlvbiBjb21lcyBmcm9tIHRo ZSBPcmFmY2UgZXh0ZW5zaW9uLgoKVGhlIGNvbmZpZ3VyYXRpb24gb2YgdGhlIG9sZCBhbmQgbmV3 IGRhdGFiYXNlcyBpcyBhcyBmb2xsb3dzLgoKCgoKRGF0YWJhc2Ugc2VydmVyIChvbGQpOiBQb3N0 Z3JlU1FMIDEyLjajqG9yYWZjZTMuMTOjqQoKRGF0YWJhc2Ugc2VydmVyIChuZXcpOiBQb3N0Z3Jl U1FMIDEyLjEzo6hvcmFmY2UzLjI0o6kKCgoKClRoZSBuZXcgZGF0YWJhc2UgaGFzIHN1Y2Nlc3Nm dWxseSBpbnN0YWxsZWQgdGhlIG9yYWZjZSAzLjI0IGV4dGVuc2lvbi4KCkl0IGRvZXMgbm90IG9j Y3VyIGluICJQb3N0Z3JlU1FMIDEyLjYgYW5kIG9yYWZjZSAzLjEzIiwgCgpidXQgb2NjdXJzIGlu ICJQb3N0Z3JlU1FMIDEyLjEzIGFuZCBvcmFmY2UgMy4yNCIsIAoKc28gZWl0aGVyIHRoZSBkaWZm ZXJlbmNlIGJldHdlZW4gMTIuNiBhbmQgMTIuMTMgb3IgdGhlIGRpZmZlcmVuY2UgYmV0d2VlbiBv cmFmY2UgMy4xMyBhbmQgMy4yNCBpcyBzdXNwaWNpb3VzLgoKCgoKV2hhdCBpcyB0aGUgcmVhc29u IGZvciB0aGUgcHJvYmxlbSBhbmQgaG93IHRvIGZpeCB0aGUgZXJyb3I/CgoKCgpSZWdhcmRzCgoK ------=_Part_97153_2017448864.1688635161184 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxwIHN0eWxlPSJtYXJnaW46MDsiPkhpLCZuYnNwOzwvcD48cCBz dHlsZT0ibWFyZ2luOjA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPkkgdXBncmFkZWQg dGhlIHZlcnNpb24gb2YgUG9zdGdyZVNRTCBmcm9tIDEyLjYgdG8gMTIuMTMsJm5ic3A7PC9wPjxw IHN0eWxlPSJtYXJnaW46MDsiPndoZW4gSSBleGVjdXRlIHRoZSBzcWwgYmVsb3cgLCB0aGUgdG9f Y2hhciBmdW5jdGlvbiBjYXVzZWQgdGhlIGZvbGxvd2luZyBlcnJvci48L3A+PHAgc3R5bGU9Im1h cmdpbjowOyI+PGJyPjwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij4tLS0tLS0tLS0tLS0tLS1TUUwt LS0tLS0tLS0tLS0tLS0tLS08L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+c2VsZWN0IFRPX0NIQVIo JzEwMDAwMDAnKTs8L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+PGJyPjwvcD48cCBzdHlsZT0ibWFy Z2luOjA7Ij5FUlJPUjombmJzcDsgZnVuY3Rpb24gdG9fY2hhcih1bmtub3duKSBpcyBub3QgdW5p cXVlIGF0IGNoYXJhY3RlciA4PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPkhJTlQ6Jm5ic3A7IENv dWxkIG5vdCBjaG9vc2UgYSBiZXN0IGNhbmRpZGF0ZSBmdW5jdGlvbi4gWW91IG1pZ2h0IG5lZWQg dG8gYWRkIGV4cGxpY2l0IHR5cGUgY2FzdHMuPC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPjxicj48 L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+VGhlcmUgaXMgbm8gcHJvYmxlbSBiZWZvcmUgdGhlIHVw Z3JhZGUgYW5kIHRvX2NoYXIgZnVuY3Rpb24gY29tZXMgZnJvbSB0aGUgT3JhZmNlIGV4dGVuc2lv bi48L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+VGhlIGNvbmZpZ3VyYXRpb24gb2YgdGhlIG9sZCBh bmQgbmV3IGRhdGFiYXNlcyBpcyBhcyBmb2xsb3dzLjwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij48 YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPkRhdGFiYXNlIHNlcnZlciAob2xkKTogUG9zdGdy ZVNRTCAxMi42o6hvcmFmY2UzLjEzo6k8L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+RGF0YWJhc2Ug c2VydmVyIChuZXcpOiBQb3N0Z3JlU1FMIDEyLjEzo6hvcmFmY2UzLjI0o6k8L3A+PHAgc3R5bGU9 Im1hcmdpbjowOyI+PGJyPjwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij5UaGUgbmV3IGRhdGFiYXNl IGhhcyBzdWNjZXNzZnVsbHkgaW5zdGFsbGVkIHRoZSBvcmFmY2UgMy4yNCBleHRlbnNpb24uPC9w PjxwIHN0eWxlPSJtYXJnaW46MDsiPkl0IGRvZXMgbm90IG9jY3VyIGluICJQb3N0Z3JlU1FMIDEy LjYgYW5kIG9yYWZjZSAzLjEzIiwmbmJzcDs8L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+YnV0IG9j Y3VycyBpbiAiUG9zdGdyZVNRTCAxMi4xMyBhbmQgb3JhZmNlIDMuMjQiLCZuYnNwOzwvcD48cCBz dHlsZT0ibWFyZ2luOjA7Ij5zbyBlaXRoZXIgdGhlIGRpZmZlcmVuY2UgYmV0d2VlbiAxMi42IGFu ZCAxMi4xMyBvciB0aGUgZGlmZmVyZW5jZSBiZXR3ZWVuIG9yYWZjZSAzLjEzIGFuZCAzLjI0IGlz IHN1c3BpY2lvdXMuPC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPjxicj48L3A+PHAgc3R5bGU9Im1h cmdpbjowOyI+V2hhdCBpcyB0aGUgcmVhc29uIGZvciB0aGUgcHJvYmxlbSBhbmQgaG93IHRvIGZp eCB0aGUgZXJyb3I/PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPjxicj48L3A+PHAgc3R5bGU9Im1h cmdpbjowOyI+UmVnYXJkczwvcD48ZGl2Pjxicj48L2Rpdj48L2Rpdj4= ------=_Part_97153_2017448864.1688635161184--