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 1pp7nO-00070t-4b for pgsql-general@arkaria.postgresql.org; Wed, 19 Apr 2023 13:24:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pp7nM-0005ko-RI for pgsql-general@arkaria.postgresql.org; Wed, 19 Apr 2023 13:24:24 +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 1pp7nL-0005ke-Vc for pgsql-general@lists.postgresql.org; Wed, 19 Apr 2023 13:24:24 +0000 Received: from m1550.mail.126.com ([220.181.15.50]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pp7nG-000gvt-2K for pgsql-general@lists.postgresql.org; Wed, 19 Apr 2023 13:24:21 +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=VFRkg+JM6yZnhn6tXF+QPmWMY0fZIk7LEz51K2ojXXY=; b=A lmiT1XPPdR7zTa3xXzRmC3McXjwk5Fj+Dq6FYkiTUG/OuHydkqpgNBsAVLlt1xxj kBs4+2/aAR4L/FdOOzAK6ItfrAUWwbOvnxkl/sqh1d87pEgtrFw0dK0E5WtnXgQI 8gOxrab1+XytUaesrYGE6ObiyTZK7/NBj5IJUrONm4= Received: from gzhcoder$126.com ( [211.144.19.63] ) by ajax-webmail-wmsvr50 (Coremail) ; Wed, 19 Apr 2023 21:24:09 +0800 (CST) X-Originating-IP: [211.144.19.63] Date: Wed, 19 Apr 2023 21:24:09 +0800 (CST) From: gzh To: pgsql-general@lists.postgresql.org Subject: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist 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_QuyTA/Wav04v7yCYZ+kWk08Thek/WcuxufQh3I9WO500uCr06DE9YGJ/Mkbr++SVOju3rQWUbR1B1shrdohjVq4tHzd8K8oBTJKLngGp73YF Content-Type: multipart/alternative; boundary="----=_Part_122583_1252788753.1681910649004" MIME-Version: 1.0 Message-ID: <328d2a0.828a.18799afd0ac.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: MsqowAC3zqp66z9ke+AQAA--.45957W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbizgtWWV8RQzQCKAACsb X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_122583_1252788753.1681910649004 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 SGksIAoKCgoKSSB1cGdyYWRlZCB0aGUgdmVyc2lvbiBvZiBQb3N0Z3JlU1FMIGZyb20gMTIuMTAg dG8gMTIuMTMsIAoKd2hlbiBJIGluc2VydCBkYXRhIGludG8gdGhlIHRfbXN0ciB0YWJsZSwgdGhl IHRvX2NoYXIgZnVuY3Rpb24gaW4gdGhlIHRfbXN0cidzIHRyaWdnZXIgY2F1c2VkIHRoZSBmb2xs b3dpbmcgZXJyb3IuCgoKCgpwc3FsOnRfbXN0ci5zcWw6OTk0OiBFUlJPUjogIGZ1bmN0aW9uIHRv X2NoYXIobnVtZXJpYykgZG9lcyBub3QgZXhpc3QKCgoKClRoZXJlIGlzIG5vIHByb2JsZW0gYmVm b3JlIHRoZSB1cGdyYWRlIGFuZCB0b19jaGFyKG51bWVyaWMpIGZ1bmN0aW9uIGNvbWVzIGZyb20g dGhlIE9yYWZjZSBleHRlbnNpb24uCgpUaGUgY29uZmlndXJhdGlvbiBvZiB0aGUgb2xkIGFuZCBu ZXcgZGF0YWJhc2VzIGlzIGFzIGZvbGxvd3MuCgoKCgpEYXRhYmFzZSBzZXJ2ZXIgKG9sZCk6IFBv c3RncmVTUUwgMTIuMTCjqG9yYWZjZTMuMTWjqQoKRGF0YWJhc2Ugc2VydmVyIChuZXcpOiBQb3N0 Z3JlU1FMIDEyLjEzo6hvcmFmY2UzLjI0o6kKCgoKClRoZSBuZXcgZGF0YWJhc2UgaGFzIHN1Y2Nl c3NmdWxseSBpbnN0YWxsZWQgdGhlIG9yYWZjZSAzLjI0IGV4dGVuc2lvbi4KCkl0IGRvZXMgbm90 IG9jY3VyIGluICJQb3N0Z3JlU1FMIDEyLjEwIGFuZCBvcmFmY2UgMy4xNSIsIAoKYnV0IG9jY3Vy cyBpbiAiUG9zdGdyZVNRTCAxMi4xMyBhbmQgb3JhZmNlIDMuMjQiLCAKCnNvIGVpdGhlciB0aGUg ZGlmZmVyZW5jZSBiZXR3ZWVuIDEyLjEwIGFuZCAxMi4xMyBvciB0aGUgZGlmZmVyZW5jZSBiZXR3 ZWVuIG9yYWZjZSAzLjE1IGFuZCAzLjI0IGlzIHN1c3BpY2lvdXMuCgoKCgpXaGF0IGlzIHRoZSBy ZWFzb24gZm9yIHRoZSBwcm9ibGVtPwoKCgoKUmVnYXJkcwoKCg== ------=_Part_122583_1252788753.1681910649004 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxwIHN0eWxlPSJtYXJnaW46MDsiPkhpLCZuYnNwOzwvcD48cCBz dHlsZT0ibWFyZ2luOjA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPkkgdXBncmFkZWQg dGhlIHZlcnNpb24gb2YgUG9zdGdyZVNRTCBmcm9tIDEyLjEwIHRvIDEyLjEzLCZuYnNwOzwvcD48 cCBzdHlsZT0ibWFyZ2luOjA7Ij53aGVuIEkgaW5zZXJ0IGRhdGEgaW50byB0aGUgdF9tc3RyIHRh YmxlLCB0aGUgdG9fY2hhciBmdW5jdGlvbiBpbiB0aGUgdF9tc3RyJ3MgdHJpZ2dlciBjYXVzZWQg dGhlIGZvbGxvd2luZyBlcnJvci48L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+PGJyPjwvcD48cCBz dHlsZT0ibWFyZ2luOjA7Ij5wc3FsOnRfbXN0ci5zcWw6OTk0OiBFUlJPUjombmJzcDsgZnVuY3Rp b24gdG9fY2hhcihudW1lcmljKSBkb2VzIG5vdCBleGlzdDwvcD48cCBzdHlsZT0ibWFyZ2luOjA7 Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPlRoZXJlIGlzIG5vIHByb2JsZW0gYmVmb3Jl IHRoZSB1cGdyYWRlIGFuZCB0b19jaGFyKG51bWVyaWMpIGZ1bmN0aW9uIGNvbWVzIGZyb20gdGhl IE9yYWZjZSBleHRlbnNpb24uPC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPlRoZSBjb25maWd1cmF0 aW9uIG9mIHRoZSBvbGQgYW5kIG5ldyBkYXRhYmFzZXMgaXMgYXMgZm9sbG93cy48L3A+PHAgc3R5 bGU9Im1hcmdpbjowOyI+PGJyPjwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij5EYXRhYmFzZSBzZXJ2 ZXIgKG9sZCk6IFBvc3RncmVTUUwgMTIuMTCjqG9yYWZjZTMuMTWjqTwvcD48cCBzdHlsZT0ibWFy Z2luOjA7Ij5EYXRhYmFzZSBzZXJ2ZXIgKG5ldyk6IFBvc3RncmVTUUwgMTIuMTOjqG9yYWZjZTMu MjSjqTwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsi PlRoZSBuZXcgZGF0YWJhc2UgaGFzIHN1Y2Nlc3NmdWxseSBpbnN0YWxsZWQgdGhlIG9yYWZjZSAz LjI0IGV4dGVuc2lvbi48L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+SXQgZG9lcyBub3Qgb2NjdXIg aW4gIlBvc3RncmVTUUwgMTIuMTAgYW5kIG9yYWZjZSAzLjE1IiwmbmJzcDs8L3A+PHAgc3R5bGU9 Im1hcmdpbjowOyI+YnV0IG9jY3VycyBpbiAiUG9zdGdyZVNRTCAxMi4xMyBhbmQgb3JhZmNlIDMu MjQiLCZuYnNwOzwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij5zbyBlaXRoZXIgdGhlIGRpZmZlcmVu Y2UgYmV0d2VlbiAxMi4xMCBhbmQgMTIuMTMgb3IgdGhlIGRpZmZlcmVuY2UgYmV0d2VlbiBvcmFm Y2UgMy4xNSBhbmQgMy4yNCBpcyBzdXNwaWNpb3VzLjwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij48 YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPldoYXQgaXMgdGhlIHJlYXNvbiBmb3IgdGhlIHBy b2JsZW0/PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjow OyI+UmVnYXJkczwvcD48ZGl2Pjxicj48L2Rpdj48L2Rpdj4= ------=_Part_122583_1252788753.1681910649004--