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 1psF1F-0004EY-RI for pgsql-general@arkaria.postgresql.org; Fri, 28 Apr 2023 03:43:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1psF1E-00029R-FX for pgsql-general@arkaria.postgresql.org; Fri, 28 Apr 2023 03:43:36 +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 1psF1D-00029I-Fj for pgsql-general@lists.postgresql.org; Fri, 28 Apr 2023 03:43:36 +0000 Received: from m1524.mail.126.com ([220.181.15.24]) by magus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1psF15-005V6M-VZ for pgsql-general@lists.postgresql.org; Fri, 28 Apr 2023 03:43:33 +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=G3Amh9137BtSlS5GI5Nsl8MtQd7bCznUg4V3hHudK7o=; b=m 14/qgiD/d3JGCWBzcMHjLuN3IOWW8TT/1j9GF4LvtZjpNRmUT4idMqWss2gZ+Xlg Hka/kNsm/ffNLJP6ZQbeKgd9Y24r/69PcYcLDLksOI9s6jPn8A5sQBDbVIQ+m0oq 7WyeNMEJgAyHjs13sr1p9OaqMxAqqizdxPK+KBMW5c= Received: from gzhcoder$126.com ( [222.175.120.219, 211.144.19.63] ) by ajax-webmail-wmsvr24 (Coremail) ; Fri, 28 Apr 2023 11:43:16 +0800 (CST) X-Originating-IP: [222.175.120.219, 211.144.19.63] Date: Fri, 28 Apr 2023 11:43:16 +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: <1109902.1682604682@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> <5027d9b9.7aad.187b831fb18.Coremail.gzhcoder@126.com> <1073908593.624606.1682427189969@office.mailbox.org> <7480a292.7dc7.187c271a743.Coremail.gzhcoder@126.com> <1109902.1682604682@sss.pgh.pa.us> X-NTES-SC: AL_QuyTAPqevEsi4CacZekXnUcRhe09UMSxvfwm24RVNp80kSn/8ycbZGZED0vI+s+2Eie3qQGwfhpC6d9KTbh5fqdyke+YWRVMRVqAybNuMkEk Content-Type: multipart/alternative; boundary="----=_Part_49226_1973633206.1682653396642" MIME-Version: 1.0 Message-ID: <207c2ff5.342d.187c5f53ea3.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: GMqowAD3Ds_UQEtkS7IUAA--.57708W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbi3BteWVpEFRgtEgACsu X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_49226_1973633206.1682653396642 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 CgoKPklmIHlvdSdyZSBwb3J0aW5nIGEgYnVuY2ggb2YgY29kZSB3cml0dGVuIGZvciBPcmFjbGUg dG8gUG9zdGdyZXMsCgo+eW91J2QgaGF2ZSB0byBydW4gYXJvdW5kIGFuZCBjaGFuZ2UgZXZlcnkg b2NjdXJyZW5jZSBvZiAiZGF0ZSIgdG8KCj4idGltZXN0YW1wIiAuLi4gdW5sZXNzIHlvdSBpbnN0 YWxsIG9yYWZjZSwgaW4gd2hpY2ggY2FzZSB5b3UgY2FuCgo+cmVseSBvbiB0aGlzIGFsaWFzIHR5 cGUgdGhhdCBvcmFmY2UgY3JlYXRlcy4gIEJ1dCB5b3UgZG8gdGhlbiBoYXZlCgo+dHdvIHR5cGVz IG5hbWVkICJkYXRlIiBpbiB0aGUgc3lzdGVtLCBzbyB5b3UgaGF2ZSB0byBiZSBjYXJlZnVsCgo+ YWJvdXQgc2VhcmNoX3BhdGggc2V0dGluZ3Mgb3IgeW91J2xsIGdldCBtb3JlIGNvbmZ1c2lvbiB0 aGFuIGl0J3MKCj53b3J0aC4KCldoZW4gSSBwdXQgdGhlIG9yYWNsZSBzY2hlbWEgaW4gdGhlIHNl YXJjaF9wYXRoIGJlaGluZCB0aGUgcGdfY2F0YWxvZyBzY2hlbWEsIAoKZXZlbiBpZiBJIGRvbid0 IG1ha2UgYW55IGNoYW5nZXMgdG8gdGhlIHRvX2RhdGUodGV4dCkgZnVuY3Rpb25zIG9mIHRoZSBw dWJsaWMgc2NoZW1hLCAKCnRoZSBhcHBsaWNhdGlvbiBiZWhhdmVzIHRoZSBzYW1lIGFzIHRoZSBv bGQgdmVyc2lvbiBvZiB0aGUgZGF0YWJhc2UoUG9zdGdyZVNRTCAxMi4xMCBhbmQgb3JhZmNlIDMu MTUpLiAKCkNhbiBJIHVuZGVyc3RhbmQgdGhhdCB3aGVuIHRoZSBwZ19jYXRhbG9nIHNjaGVtYSBp cyBpbiBmcm9udCBvZiB0aGUgb3JhY2xlIHNjaGVtYSwgCgp0aGUgZGF0ZSB0eXBlIHRoYXQgZG9l cyBub3Qgc3BlY2lmeSB0aGUgc2NoZW1hIGluIGFsbCBmdW5jdGlvbnMgdGFrZXMgdGhlIGRhdGUg dHlwZSAKCm9mIHBnX2NhdGFsb2cuZGF0ZSBmaXJzdCwgc28gc2V0dGluZyB0aGUgc2VhcmNoX3Bh dGggYXMgYmVsb3cgaXMgYWxzbyBhIHNvbHV0aW9uLgoKCgoKcG9zdGdyZXM9IyBzaG93IHNlYXJj aF9wYXRoOwoKICAgICAgICAgICAgIHNlYXJjaF9wYXRoCgotLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tCgogIiR1c2VyIiwgcHVibGljLCBwZ19jYXRhbG9nLCBvcmFjbGUKCgpB dCAyMDIzLTA0LTI3IDIyOjExOjIyLCAiVG9tIExhbmUiIDx0Z2xAc3NzLnBnaC5wYS51cz4gd3Jv dGU6Cj5nemggIDxnemhjb2RlckAxMjYuY29tPiB3cml0ZXM6Cj4+IEkgZGlkIHRoZSBmb2xsb3dp bmcgdHdvIHRlc3RzIGFuZCBmb3VuZCB0aGF0IHRoZSByZXR1cm4gdmFsdWUgb2YgcGdfY2F0YWxv Zy5kYXRlIGFuZCBvcmFjbGUuZGF0ZSBhcmUgaW5jb25zaXN0ZW50Lgo+Cj5ZZWFoIC4uLiB0aGF0 J3MgcHJldHR5IG11Y2ggdGhlIHBvaW50LiAgT3JhY2xlIHVzZXMgdGhlIG5hbWUgImRhdGUiCj5m b3IgYSBkYXRhIHR5cGUgdGhhdCBQb3N0Z3JlcyAoYW5kIHRoZSBTUUwgc3RhbmRhcmQpIGNhbGxz IGEgInRpbWVzdGFtcCIuCj5UaGF0J3MgdmVyeSBhbmNpZW50IG9uIHRoZWlyIHNpZGUgYW5kIEkg ZG91YnQgdGhleSdsbCBldmVyIGNoYW5nZSBpdC4KPgo+SWYgeW91J3JlIHBvcnRpbmcgYSBidW5j aCBvZiBjb2RlIHdyaXR0ZW4gZm9yIE9yYWNsZSB0byBQb3N0Z3JlcywKPnlvdSdkIGhhdmUgdG8g cnVuIGFyb3VuZCBhbmQgY2hhbmdlIGV2ZXJ5IG9jY3VycmVuY2Ugb2YgImRhdGUiIHRvCj4idGlt ZXN0YW1wIiAuLi4gdW5sZXNzIHlvdSBpbnN0YWxsIG9yYWZjZSwgaW4gd2hpY2ggY2FzZSB5b3Ug Y2FuCj5yZWx5IG9uIHRoaXMgYWxpYXMgdHlwZSB0aGF0IG9yYWZjZSBjcmVhdGVzLiAgQnV0IHlv dSBkbyB0aGVuIGhhdmUKPnR3byB0eXBlcyBuYW1lZCAiZGF0ZSIgaW4gdGhlIHN5c3RlbSwgc28g eW91IGhhdmUgdG8gYmUgY2FyZWZ1bAo+YWJvdXQgc2VhcmNoX3BhdGggc2V0dGluZ3Mgb3IgeW91 J2xsIGdldCBtb3JlIGNvbmZ1c2lvbiB0aGFuIGl0J3MKPndvcnRoLgo+Cj4JCQlyZWdhcmRzLCB0 b20gbGFuZQo= ------=_Part_49226_1973633206.1682653396642 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxkaXYgc3R5 bGU9InBvc2l0aW9uOnJlbGF0aXZlO3pvb206MSI+PC9kaXY+PGRpdiBpZD0iZGl2TmV0ZWFzZU1h aWxDYXJkIj48L2Rpdj48cCBzdHlsZT0ibWFyZ2luOiAwOyI+Jmd0O0lmIHlvdSdyZSBwb3J0aW5n IGEgYnVuY2ggb2YgY29kZSB3cml0dGVuIGZvciBPcmFjbGUgdG8gUG9zdGdyZXMsPC9wPjxwIHN0 eWxlPSJtYXJnaW46IDA7Ij4mZ3Q7eW91J2QgaGF2ZSB0byBydW4gYXJvdW5kIGFuZCBjaGFuZ2Ug ZXZlcnkgb2NjdXJyZW5jZSBvZiAiZGF0ZSIgdG88L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPiZn dDsidGltZXN0YW1wIiAuLi4gdW5sZXNzIHlvdSBpbnN0YWxsIG9yYWZjZSwgaW4gd2hpY2ggY2Fz ZSB5b3UgY2FuPC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij4mZ3Q7cmVseSBvbiB0aGlzIGFsaWFz IHR5cGUgdGhhdCBvcmFmY2UgY3JlYXRlcy4mbmJzcDsgQnV0IHlvdSBkbyB0aGVuIGhhdmU8L3A+ PHAgc3R5bGU9Im1hcmdpbjogMDsiPiZndDt0d28gdHlwZXMgbmFtZWQgImRhdGUiIGluIHRoZSBz eXN0ZW0sIHNvIHlvdSBoYXZlIHRvIGJlIGNhcmVmdWw8L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsi PiZndDthYm91dCBzZWFyY2hfcGF0aCBzZXR0aW5ncyBvciB5b3UnbGwgZ2V0IG1vcmUgY29uZnVz aW9uIHRoYW4gaXQnczwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+Jmd0O3dvcnRoLjwvcD48cCBz dHlsZT0ibWFyZ2luOiAwOyI+V2hlbiBJIHB1dCB0aGUgb3JhY2xlIHNjaGVtYSBpbiB0aGUgc2Vh cmNoX3BhdGggYmVoaW5kIHRoZSBwZ19jYXRhbG9nIHNjaGVtYSwmbmJzcDs8L3A+PHAgc3R5bGU9 Im1hcmdpbjogMDsiPmV2ZW4gaWYgSSBkb24ndCBtYWtlIGFueSBjaGFuZ2VzIHRvIHRoZSZuYnNw OzxzcGFuIHN0eWxlPSJmb250LWZhbWlseTogbW9ub3NwYWNlLCBtb25vc3BhY2U7IGZvbnQtc2l6 ZTogMTAuNzMzM3B4OyB3aGl0ZS1zcGFjZTogcHJlLXdyYXA7Ij50b19kYXRlKHRleHQpPC9zcGFu PiZuYnNwO2Z1bmN0aW9ucyBvZiB0aGUgcHVibGljIHNjaGVtYSwmbmJzcDs8L3A+PHAgc3R5bGU9 Im1hcmdpbjogMDsiPnRoZSBhcHBsaWNhdGlvbiBiZWhhdmVzIHRoZSBzYW1lIGFzIHRoZSBvbGQg dmVyc2lvbiBvZiB0aGUgZGF0YWJhc2UoPHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5OiBtb25vc3Bh Y2UsIG1vbm9zcGFjZTsgZm9udC1zaXplOiAxMC43MzMzcHg7IHdoaXRlLXNwYWNlOiBwcmUtd3Jh cDsiPlBvc3RncmVTUUwgMTIuMTAgYW5kIG9yYWZjZSAzLjE1PC9zcGFuPikuJm5ic3A7PC9wPjxw IHN0eWxlPSJtYXJnaW46IDA7Ij5DYW4gSSB1bmRlcnN0YW5kIHRoYXQgd2hlbiB0aGUgcGdfY2F0 YWxvZyBzY2hlbWEgaXMgaW4gZnJvbnQgb2YgdGhlIG9yYWNsZSBzY2hlbWEsJm5ic3A7PC9wPjxw IHN0eWxlPSJtYXJnaW46IDA7Ij50aGUgZGF0ZSB0eXBlIHRoYXQgZG9lcyBub3Qgc3BlY2lmeSB0 aGUgc2NoZW1hIGluIGFsbCBmdW5jdGlvbnMgdGFrZXMgdGhlIGRhdGUgdHlwZSZuYnNwOzwvcD48 cCBzdHlsZT0ibWFyZ2luOiAwOyI+b2YgcGdfY2F0YWxvZy5kYXRlIGZpcnN0LCBzbyBzZXR0aW5n IHRoZSBzZWFyY2hfcGF0aCBhcyBiZWxvdyBpcyBhbHNvIGEgc29sdXRpb24uPC9wPjxwIHN0eWxl PSJtYXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij5wb3N0Z3Jlcz0jIHNo b3cgc2VhcmNoX3BhdGg7PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij4mbmJzcDsgJm5ic3A7ICZu YnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDtzZWFyY2hfcGF0aDwvcD48cCBzdHlsZT0i bWFyZ2luOiAwOyI+LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTwvcD48cCBz dHlsZT0ibWFyZ2luOiAwOyI+Jm5ic3A7IiR1c2VyIiwgcHVibGljLCBwZ19jYXRhbG9nLCBvcmFj bGU8L3A+PHByZT48YnI+QXQgMjAyMy0wNC0yNyAyMjoxMToyMiwgIlRvbSBMYW5lIiAmbHQ7dGds QHNzcy5wZ2gucGEudXMmZ3Q7IHdyb3RlOgomZ3Q7Z3poICAmbHQ7Z3poY29kZXJAMTI2LmNvbSZn dDsgd3JpdGVzOgomZ3Q7Jmd0OyBJIGRpZCB0aGUgZm9sbG93aW5nIHR3byB0ZXN0cyBhbmQgZm91 bmQgdGhhdCB0aGUgcmV0dXJuIHZhbHVlIG9mIHBnX2NhdGFsb2cuZGF0ZSBhbmQgb3JhY2xlLmRh dGUgYXJlIGluY29uc2lzdGVudC4KJmd0OwomZ3Q7WWVhaCAuLi4gdGhhdCdzIHByZXR0eSBtdWNo IHRoZSBwb2ludC4gIE9yYWNsZSB1c2VzIHRoZSBuYW1lICJkYXRlIgomZ3Q7Zm9yIGEgZGF0YSB0 eXBlIHRoYXQgUG9zdGdyZXMgKGFuZCB0aGUgU1FMIHN0YW5kYXJkKSBjYWxscyBhICJ0aW1lc3Rh bXAiLgomZ3Q7VGhhdCdzIHZlcnkgYW5jaWVudCBvbiB0aGVpciBzaWRlIGFuZCBJIGRvdWJ0IHRo ZXknbGwgZXZlciBjaGFuZ2UgaXQuCiZndDsKJmd0O0lmIHlvdSdyZSBwb3J0aW5nIGEgYnVuY2gg b2YgY29kZSB3cml0dGVuIGZvciBPcmFjbGUgdG8gUG9zdGdyZXMsCiZndDt5b3UnZCBoYXZlIHRv IHJ1biBhcm91bmQgYW5kIGNoYW5nZSBldmVyeSBvY2N1cnJlbmNlIG9mICJkYXRlIiB0bwomZ3Q7 InRpbWVzdGFtcCIgLi4uIHVubGVzcyB5b3UgaW5zdGFsbCBvcmFmY2UsIGluIHdoaWNoIGNhc2Ug eW91IGNhbgomZ3Q7cmVseSBvbiB0aGlzIGFsaWFzIHR5cGUgdGhhdCBvcmFmY2UgY3JlYXRlcy4g IEJ1dCB5b3UgZG8gdGhlbiBoYXZlCiZndDt0d28gdHlwZXMgbmFtZWQgImRhdGUiIGluIHRoZSBz eXN0ZW0sIHNvIHlvdSBoYXZlIHRvIGJlIGNhcmVmdWwKJmd0O2Fib3V0IHNlYXJjaF9wYXRoIHNl dHRpbmdzIG9yIHlvdSdsbCBnZXQgbW9yZSBjb25mdXNpb24gdGhhbiBpdCdzCiZndDt3b3J0aC4K Jmd0OwomZ3Q7CQkJcmVnYXJkcywgdG9tIGxhbmUKPC9wcmU+PC9kaXY+ ------=_Part_49226_1973633206.1682653396642--