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 1prGx2-0000ec-AA for pgsql-general@arkaria.postgresql.org; Tue, 25 Apr 2023 11:35:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1prGx1-0006UP-1i for pgsql-general@arkaria.postgresql.org; Tue, 25 Apr 2023 11:35:15 +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 1prGwz-0006UG-Uf for pgsql-general@lists.postgresql.org; Tue, 25 Apr 2023 11:35:14 +0000 Received: from m1550.mail.126.com ([220.181.15.50]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1prGwv-001o1J-5S for pgsql-general@lists.postgresql.org; Tue, 25 Apr 2023 11:35:12 +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=BKyD4abwB9t8zp9qAK8tcKwXgMh392jUwzS/u3D+c+o=; b=S 1ByYrXUsCMcZTxsgglGEcJmetIkWsdTCbYnEkP+8tNI2Xi+OL/gCwQ6MC78SBdEH 5rpd2kzOu0M4eqXoFwyyiPnRMRxz4IaMTltFp0YdMZUkk26RzrGQcsmDQ4wSeUWX Z0TEMdXGTm/taXkxZp/fxjt5PKlsT/kyJn8rOAh43w= Received: from gzhcoder$126.com ( [222.175.120.219, 211.144.19.63] ) by ajax-webmail-wmsvr50 (Coremail) ; Tue, 25 Apr 2023 19:34:56 +0800 (CST) X-Originating-IP: [222.175.120.219, 211.144.19.63] Date: Tue, 25 Apr 2023 19:34:56 +0800 (CST) From: gzh To: "Tom Lane" Cc: "Erik Wienhold" , pgsql-general@lists.postgresql.org Subject: Re: 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 In-Reply-To: <2993958.1681924695@sss.pgh.pa.us> References: <328d2a0.828a.18799afd0ac.Coremail.gzhcoder@126.com> <1597875806.606392.1681915893771@office.mailbox.org> <70c95d95.7a58.1879a77ed4f.Coremail.gzhcoder@126.com> <2993958.1681924695@sss.pgh.pa.us> X-NTES-SC: AL_QuyTAPiZvUwi4CCaZ+kXnUcRhe09UMSxvfwm24RVNp80uCrvwAMcYmB8OHvM382sCwmWrwetUT9F9Pp1bY9SZZ53u3snQN0BWkqw88C85PA2 Content-Type: multipart/alternative; boundary="----=_Part_115040_582163123.1682422496024" MIME-Version: 1.0 Message-ID: <5027d9b9.7aad.187b831fb18.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: MsqowAD3_6vhukdkfG4UAA--.45213W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbizg5cWV8RQ1CaXQACsd X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_115040_582163123.1682422496024 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 PlRoZSBzb2x1dGlvbiBpcyB0aGUgc2FtZSB3aGV0aGVyIHlvdSB1cGdyYWRlIG9yIG5vdDogeW91 IG5lZWQKPnRvIGFkanVzdCB5b3VyIHNlYXJjaF9wYXRoIHRvIGluY2x1ZGUgdGhlICJvcmFjbGUi IHNjaGVtYSwKPm9yIGVsc2UgZXhwbGljaXRseSBxdWFsaWZ5IHJlZmVyZW5jZXMgdG8gb3JhZmNl IGZ1bmN0aW9ucy5UaGFuayB5b3UgdmVyeSBtdWNoIGZvciB5b3VyIGhlbHAuCgoKVG8gdXNlIHRo ZSB0b19kYXRlIGZ1bmN0aW9ucyBvZiBPcmFmY2UgMy4wLjEsIHdlIGNyZWF0ZWQgdGhlIGZvbGxv d2luZyB0b19kYXRlIGZ1bmN0aW9uIGluIHRoZSBwdWJsaWMgc2NoZW1hIG9mIHRoZSBvbGQgZGF0 YWJhc2UuCgoKLS0tLS0KQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gdG9fZGF0ZShzdHIgdGV4 dCkgUkVUVVJOUyBkYXRlIEFTICQkIFNFTEVDVCAkMTo6ZGF0ZTsgJCQgTEFOR1VBR0Ugc3FsIElN TVVUQUJMRSBTVFJJQ1Q7IENPTU1FTlQgT04gRlVOQ1RJT04gcHVibGljLnRvX2RhdGUodGV4dCkg SVMgJ0NvbnZlcnQgc3RyaW5nIHRvIGRhdGUnOwotLS0tLQoKClRvIGF2b2lkIHVzaW5nIGEgdG9f ZGF0ZSBmdW5jdGlvbiB3aXRoIHRoZSBzYW1lIG5hbWUgYW5kIHBhcmFtZXRlciBpbiB0aGUgcGdf Y2F0YWxvZyBzY2hlbWEgZmlyc3QsIHRoZSBzZWFyY2hfcGF0aCBvZiB0aGUgb2xkIGRhdGFiYXNl IGlzIHNldCBhcyBmb2xsb3dzOgoKCiIkdXNlciIsIHB1YmxpYywgcGdfY2F0YWxvZwoKCk1ha2Ug c3VyZSB0aGF0IHB1YmxpYyBpcyBzZWFyY2hlZCBiZWZvcmUgcGdfY2F0YWxvZy4KQWZ0ZXIgdGhl IGRhdGFiYXNlIGlzIHVwZ3JhZGVkLCBpbiBvcmRlciB0byBzb2x2ZSB0aGUgY2hhbmdlcyBpbiBP cmFjbGUgMy4yNCwgd2UgaGF2ZSBhZGRlZCBvcmFjbGUgc2NoZW1hIHRvIHRoZSBzZWFyY2hfcGF0 aCwgYXMgc2hvd24gYmVsb3ejugoKCiIkdXNlciIsIHB1YmxpYywgb3JhY2xlLCBwZ19jYXRhbG9n CgoKVGhlIGZvbGxvd2luZyBlcnJvciBvY2N1cnJlZCB3aGVuIEkgcmFuIG15IGFwcGxpY2F0aW9u LgoKCjQyUDEzOkVSUk9SOjQyUDEzOiByZXR1cm4gdHlwZSBtaXNtYXRjaCBpbiBmdW5jdGlvbiBk ZWNsYXJlZCB0byByZXR1cm4gcGdfY2F0YWxvZy5kYXRlCgoKV2hlbiBJIHB1dCB0aGUgb3JhY2xl IHNjaGVtYSBhdCB0aGUgZW5kIG9mIHRoZSBzZWFyY2hfcGF0aCwgdGhlIHByb2JsZW0gd2FzIHNv bHZlZC4gClRoZSBzZWFyY2hfcGF0aCBzZXR0aW5ncyB3aXRob3V0IHByb2JsZW1zIGFyZSBhcyBm b2xsb3dzOgoKCiIkdXNlciIsIHB1YmxpYywgcGdfY2F0YWxvZywgb3JhY2xlCgoKV2h5IGRvZXMg aXQgcmVwb3J0IGFuIGVycm9yIHdoZW4gaSBwdXQgb3JhY2xlIGJldHdlZW4gcHVibGljIGFuZCBw Z19jYXRhbG9nPwoKCgoKCgoKCgoKCkF0IDIwMjMtMDQtMjAgMDE6MTg6MTUsICJUb20gTGFuZSIg PHRnbEBzc3MucGdoLnBhLnVzPiB3cm90ZToKPmd6aCAgPGd6aGNvZGVyQDEyNi5jb20+IHdyaXRl czoKPj4gVGhhbmsgeW91IGZvciB5b3VyIHByb21wdCByZXBseS4gCj4+IElzIHRoZXJlIGFub3Ro ZXIgc29sdXRpb24gaWYgdGhlIGRhdGFiYXNlIGlzIG5vdCB1cGdyYWRlZCB0byAxMi4xND8KPgo+ VGhlIHNvbHV0aW9uIGlzIHRoZSBzYW1lIHdoZXRoZXIgeW91IHVwZ3JhZGUgb3Igbm90OiB5b3Ug bmVlZAo+dG8gYWRqdXN0IHlvdXIgc2VhcmNoX3BhdGggdG8gaW5jbHVkZSB0aGUgIm9yYWNsZSIg c2NoZW1hLAo+b3IgZWxzZSBleHBsaWNpdGx5IHF1YWxpZnkgcmVmZXJlbmNlcyB0byBvcmFmY2Ug ZnVuY3Rpb25zLgo+Cj4JCQlyZWdhcmRzLCB0b20gbGFuZQo= ------=_Part_115040_582163123.1682422496024 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPjxwcmU+Jmd0O1RoZSBz b2x1dGlvbiBpcyB0aGUgc2FtZSB3aGV0aGVyIHlvdSB1cGdyYWRlIG9yIG5vdDogeW91IG5lZWQK Jmd0O3RvIGFkanVzdCB5b3VyIHNlYXJjaF9wYXRoIHRvIGluY2x1ZGUgdGhlICJvcmFjbGUiIHNj aGVtYSwKJmd0O29yIGVsc2UgZXhwbGljaXRseSBxdWFsaWZ5IHJlZmVyZW5jZXMgdG8gb3JhZmNl IGZ1bmN0aW9ucy48L3ByZT48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5UaGFuayB5b3Ug dmVyeSBtdWNoIGZvciB5b3VyIGhlbHAuPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+PGJy PjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPlRvIHVzZSB0aGUgdG9fZGF0ZSBmdW5jdGlv bnMgb2YgT3JhZmNlIDMuMC4xLCB3ZSBjcmVhdGVkIHRoZSBmb2xsb3dpbmcgdG9fZGF0ZSBmdW5j dGlvbiBpbiB0aGUgcHVibGljIHNjaGVtYSBvZiB0aGUgb2xkIGRhdGFiYXNlLjwvZGl2PjxkaXYg c3R5bGU9Im1hcmdpbjogMDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij48ZGl2 IHN0eWxlPSJtYXJnaW46IDA7Ij4tLS0tLTwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPkNS RUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHRvX2RhdGUoc3RyIHRleHQpIFJFVFVSTlMgZGF0ZSBB UyAkJCBTRUxFQ1QgJDE6OmRhdGU7ICQkIExBTkdVQUdFIHNxbCBJTU1VVEFCTEUgU1RSSUNUOyBD T01NRU5UIE9OIEZVTkNUSU9OIHB1YmxpYy50b19kYXRlKHRleHQpIElTICdDb252ZXJ0IHN0cmlu ZyB0byBkYXRlJzs8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij4tLS0tLTwvZGl2PjxkaXYg c3R5bGU9Im1hcmdpbjogMDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5UbyBh dm9pZCB1c2luZyBhIHRvX2RhdGUgZnVuY3Rpb24gd2l0aCB0aGUgc2FtZSBuYW1lIGFuZCBwYXJh bWV0ZXIgaW4gdGhlIHBnX2NhdGFsb2cgc2NoZW1hIGZpcnN0LCB0aGUgc2VhcmNoX3BhdGggb2Yg dGhlIG9sZCBkYXRhYmFzZSBpcyBzZXQgYXMgZm9sbG93czo8L2Rpdj48ZGl2IHN0eWxlPSJtYXJn aW46IDA7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+IiR1c2VyIiwgcHVibGlj LCBwZ19jYXRhbG9nPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvZGl2PjxkaXYg c3R5bGU9Im1hcmdpbjogMDsiPk1ha2Ugc3VyZSB0aGF0IHB1YmxpYyBpcyBzZWFyY2hlZCBiZWZv cmUgcGdfY2F0YWxvZy48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5BZnRlciB0aGUgZGF0 YWJhc2UgaXMgdXBncmFkZWQsIGluIG9yZGVyIHRvIHNvbHZlIHRoZSBjaGFuZ2VzIGluIE9yYWNs ZSAzLjI0LCB3ZSBoYXZlIGFkZGVkIG9yYWNsZSBzY2hlbWEgdG8gdGhlIHNlYXJjaF9wYXRoLCBh cyBzaG93biBiZWxvd6O6PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvZGl2Pjxk aXYgc3R5bGU9Im1hcmdpbjogMDsiPiIkdXNlciIsIHB1YmxpYywgb3JhY2xlLCBwZ19jYXRhbG9n PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdp bjogMDsiPlRoZSBmb2xsb3dpbmcgZXJyb3Igb2NjdXJyZWQgd2hlbiBJIHJhbiBteSBhcHBsaWNh dGlvbi48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0i bWFyZ2luOiAwOyI+NDJQMTM6RVJST1I6NDJQMTM6IHJldHVybiB0eXBlIG1pc21hdGNoIGluIGZ1 bmN0aW9uIGRlY2xhcmVkIHRvIHJldHVybiBwZ19jYXRhbG9nLmRhdGU8L2Rpdj48ZGl2IHN0eWxl PSJtYXJnaW46IDA7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+V2hlbiBJIHB1 dCB0aGUgb3JhY2xlIHNjaGVtYSBhdCB0aGUgZW5kIG9mIHRoZSBzZWFyY2hfcGF0aCwgdGhlIHBy b2JsZW0gd2FzIHNvbHZlZC4mbmJzcDs8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5UaGUg c2VhcmNoX3BhdGggc2V0dGluZ3Mgd2l0aG91dCBwcm9ibGVtcyBhcmUgYXMgZm9sbG93czo8L2Rp dj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAw OyI+IiR1c2VyIiwgcHVibGljLCBwZ19jYXRhbG9nLCBvcmFjbGU8L2Rpdj48ZGl2IHN0eWxlPSJt YXJnaW46IDA7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+V2h5IGRvZXMgaXQg cmVwb3J0IGFuIGVycm9yIHdoZW4gaSBwdXQgb3JhY2xlIGJldHdlZW4gcHVibGljIGFuZCBwZ19j YXRhbG9nPzwvZGl2PjwvZGl2PjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxl PSJtYXJnaW46IDA7Ij48YnI+PC9wPjxkaXYgc3R5bGU9InBvc2l0aW9uOnJlbGF0aXZlO3pvb206 MSI+PC9kaXY+PGRpdiBpZD0iZGl2TmV0ZWFzZU1haWxDYXJkIj48L2Rpdj48cCBzdHlsZT0ibWFy Z2luOiAwOyI+PGJyPjwvcD48cHJlPjxicj5BdCAyMDIzLTA0LTIwIDAxOjE4OjE1LCAiVG9tIExh bmUiICZsdDt0Z2xAc3NzLnBnaC5wYS51cyZndDsgd3JvdGU6CiZndDtnemggICZsdDtnemhjb2Rl ckAxMjYuY29tJmd0OyB3cml0ZXM6CiZndDsmZ3Q7IFRoYW5rIHlvdSBmb3IgeW91ciBwcm9tcHQg cmVwbHkuIAomZ3Q7Jmd0OyBJcyB0aGVyZSBhbm90aGVyIHNvbHV0aW9uIGlmIHRoZSBkYXRhYmFz ZSBpcyBub3QgdXBncmFkZWQgdG8gMTIuMTQ/CiZndDsKJmd0O1RoZSBzb2x1dGlvbiBpcyB0aGUg c2FtZSB3aGV0aGVyIHlvdSB1cGdyYWRlIG9yIG5vdDogeW91IG5lZWQKJmd0O3RvIGFkanVzdCB5 b3VyIHNlYXJjaF9wYXRoIHRvIGluY2x1ZGUgdGhlICJvcmFjbGUiIHNjaGVtYSwKJmd0O29yIGVs c2UgZXhwbGljaXRseSBxdWFsaWZ5IHJlZmVyZW5jZXMgdG8gb3JhZmNlIGZ1bmN0aW9ucy4KJmd0 OwomZ3Q7CQkJcmVnYXJkcywgdG9tIGxhbmUKPC9wcmU+PC9kaXY+ ------=_Part_115040_582163123.1682422496024--