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 1ppBCu-0001cR-MW for pgsql-general@arkaria.postgresql.org; Wed, 19 Apr 2023 17:03:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppBCt-0001j7-Ng for pgsql-general@arkaria.postgresql.org; Wed, 19 Apr 2023 17:02:59 +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 1ppBCs-0001ip-Qh for pgsql-general@lists.postgresql.org; Wed, 19 Apr 2023 17:02:59 +0000 Received: from m1564.mail.126.com ([220.181.15.64]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ppBCo-000iqw-Ir for pgsql-general@lists.postgresql.org; Wed, 19 Apr 2023 17:02:57 +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=nm9qT318k+GRqPulLpM1amRNTUmDopo0AerYTQ068iI=; b=P HjgdH+d9CJUS9PlTpBtEgPb0JJyKlIZ8C+1AOazJ+Z98OTT8rU3GSG3SbB8XYsnI 3W+5VSBf2Xt69CZOxhZqiFYRzG7ilnfbqIPBbHWlkiEFukJG512FyAAyr9lspE1L 8yPDbLpyKr5pPJlhD8CVdhdTc3UoJP07w33sfVbTPw= Received: from gzhcoder$126.com ( [39.64.186.32] ) by ajax-webmail-wmsvr64 (Coremail) ; Thu, 20 Apr 2023 01:02:43 +0800 (CST) X-Originating-IP: [39.64.186.32] Date: Thu, 20 Apr 2023 01:02:43 +0800 (CST) From: gzh To: "Erik Wienhold" Cc: 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: <1597875806.606392.1681915893771@office.mailbox.org> References: <328d2a0.828a.18799afd0ac.Coremail.gzhcoder@126.com> <1597875806.606392.1681915893771@office.mailbox.org> X-NTES-SC: AL_QuyTA/WZvE8t5SWbZ+kWnEgXj+c7Xsu4u/0v34FSNps0pirs1A8cZWdOOkLKyuu/Ew+mqACKbDxSzPpfT6Rcb6vYjedvdX6j+LIVrBZG2xL6 Content-Type: multipart/alternative; boundary="----=_Part_114450_43104944.1681923763535" MIME-Version: 1.0 Message-ID: <70c95d95.7a58.1879a77ed4f.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: QMqowAB3RkS0HkBkT0QPAA--.44813W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbi3AlWWVpEFPA9XAACsD X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_114450_43104944.1681923763535 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 VGhhbmsgeW91IGZvciB5b3VyIHByb21wdCByZXBseS4gCklzIHRoZXJlIGFub3RoZXIgc29sdXRp b24gaWYgdGhlIGRhdGFiYXNlIGlzIG5vdCB1cGdyYWRlZCB0byAxMi4xND8KPkJldHRlciB1cGdy YWRlIHRvIGxhdGVzdCByZWxlYXNlIDEyLjE0LgoKCgoKCgoKCgoKCgoKCgoKCkF0IDIwMjMtMDQt MTkgMjI6NTE6MzMsICJFcmlrIFdpZW5ob2xkIiA8ZXdpZUBld2llLm5hbWU+IHdyb3RlOgo+PiBP biAxOS8wNC8yMDIzIDE1OjI0IENFU1QgZ3poIDxnemhjb2RlckAxMjYuY29tPiB3cm90ZToKPj4K Pj4gSGksCj4+Cj4+IEkgdXBncmFkZWQgdGhlIHZlcnNpb24gb2YgUG9zdGdyZVNRTCBmcm9tIDEy LjEwIHRvIDEyLjEzLAo+Cj5CZXR0ZXIgdXBncmFkZSB0byBsYXRlc3QgcmVsZWFzZSAxMi4xNC4K Pgo+PiB3aGVuIEkgaW5zZXJ0IGRhdGEgaW50byB0aGUgdF9tc3RyIHRhYmxlLCB0aGUgdG9fY2hh ciBmdW5jdGlvbiBpbiB0aGUgdF9tc3RyJ3MKPj4gdHJpZ2dlciBjYXVzZWQgdGhlIGZvbGxvd2lu ZyBlcnJvci4KPj4KPj4gcHNxbDp0X21zdHIuc3FsOjk5NDogRVJST1I6IGZ1bmN0aW9uIHRvX2No YXIobnVtZXJpYykgZG9lcyBub3QgZXhpc3QKPj4KPj4gVGhlcmUgaXMgbm8gcHJvYmxlbSBiZWZv cmUgdGhlIHVwZ3JhZGUgYW5kIHRvX2NoYXIobnVtZXJpYykgZnVuY3Rpb24gY29tZXMKPj4gZnJv bSB0aGUgT3JhZmNlIGV4dGVuc2lvbi4KPj4gVGhlIGNvbmZpZ3VyYXRpb24gb2YgdGhlIG9sZCBh bmQgbmV3IGRhdGFiYXNlcyBpcyBhcyBmb2xsb3dzLgo+Pgo+PiBEYXRhYmFzZSBzZXJ2ZXIgKG9s ZCk6IFBvc3RncmVTUUwgMTIuMTCjqG9yYWZjZTMuMTWjqQo+PiBEYXRhYmFzZSBzZXJ2ZXIgKG5l dyk6IFBvc3RncmVTUUwgMTIuMTOjqG9yYWZjZTMuMjSjqQo+Pgo+PiBUaGUgbmV3IGRhdGFiYXNl IGhhcyBzdWNjZXNzZnVsbHkgaW5zdGFsbGVkIHRoZSBvcmFmY2UgMy4yNCBleHRlbnNpb24uCj4+ IEl0IGRvZXMgbm90IG9jY3VyIGluICJQb3N0Z3JlU1FMIDEyLjEwIGFuZCBvcmFmY2UgMy4xNSIs Cj4+IGJ1dCBvY2N1cnMgaW4gIlBvc3RncmVTUUwgMTIuMTMgYW5kIG9yYWZjZSAzLjI0IiwKPj4g c28gZWl0aGVyIHRoZSBkaWZmZXJlbmNlIGJldHdlZW4gMTIuMTAgYW5kIDEyLjEzIG9yIHRoZSBk aWZmZXJlbmNlIGJldHdlZW4KPj4gb3JhZmNlIDMuMTUgYW5kIDMuMjQgaXMgc3VzcGljaW91cy4K Pj4KPj4gV2hhdCBpcyB0aGUgcmVhc29uIGZvciB0aGUgcHJvYmxlbT8KPgo+b3JhZmNlIDMuMjIg bW92ZWQgZnVuY3Rpb25zIHRvIHNjaGVtYSBvcmFjbGU6Cj4KPmh0dHBzOi8vZ2l0aHViLmNvbS9v cmFmY2Uvb3JhZmNlL2Jsb2IvYjQ5MmEwZjUwZDVlZTg2NmM5ODcwZjg4NjQwMWQ3YzM0YWQ4Y2Ni My9ORVdTI0w0LEw1Cj5odHRwczovL2dpdGh1Yi5jb20vb3JhZmNlL29yYWZjZS9jb21taXQvODZh MWI1MTQ0MGNhMzNhMDRlZjQ3ZmMzYmI3MDRkZWUyNmQxNjc1Mwo+Cj4tLQo+RXJpawo= ------=_Part_114450_43104944.1681923763535 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPlRoYW5rIHlvdSBmb3Ig eW91ciBwcm9tcHQgcmVwbHkuJm5ic3A7PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+SXMg dGhlcmUgYW5vdGhlciBzb2x1dGlvbiBpZiB0aGUgZGF0YWJhc2UgaXMgbm90IHVwZ3JhZGVkIHRv IDEyLjE0PzwvZGl2PjxwcmU+Jmd0O0JldHRlciB1cGdyYWRlIHRvIGxhdGVzdCByZWxlYXNlIDEy LjE0Lgo8L3ByZT48ZGl2Pjxicj48L2Rpdj48cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvcD48 cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwv cD48ZGl2IHN0eWxlPSJwb3NpdGlvbjpyZWxhdGl2ZTt6b29tOjEiPjwvZGl2PjxkaXYgaWQ9ImRp dk5ldGVhc2VNYWlsQ2FyZCI+PC9kaXY+PHAgc3R5bGU9Im1hcmdpbjogMDsiPjxicj48L3A+PHBy ZT48YnI+QXQgMjAyMy0wNC0xOSAyMjo1MTozMywgIkVyaWsgV2llbmhvbGQiICZsdDtld2llQGV3 aWUubmFtZSZndDsgd3JvdGU6CiZndDsmZ3Q7IE9uIDE5LzA0LzIwMjMgMTU6MjQgQ0VTVCBnemgg Jmx0O2d6aGNvZGVyQDEyNi5jb20mZ3Q7IHdyb3RlOgomZ3Q7Jmd0OwomZ3Q7Jmd0OyBIaSwKJmd0 OyZndDsKJmd0OyZndDsgSSB1cGdyYWRlZCB0aGUgdmVyc2lvbiBvZiBQb3N0Z3JlU1FMIGZyb20g MTIuMTAgdG8gMTIuMTMsCiZndDsKJmd0O0JldHRlciB1cGdyYWRlIHRvIGxhdGVzdCByZWxlYXNl IDEyLjE0LgomZ3Q7CiZndDsmZ3Q7IHdoZW4gSSBpbnNlcnQgZGF0YSBpbnRvIHRoZSB0X21zdHIg dGFibGUsIHRoZSB0b19jaGFyIGZ1bmN0aW9uIGluIHRoZSB0X21zdHIncwomZ3Q7Jmd0OyB0cmln Z2VyIGNhdXNlZCB0aGUgZm9sbG93aW5nIGVycm9yLgomZ3Q7Jmd0OwomZ3Q7Jmd0OyBwc3FsOnRf bXN0ci5zcWw6OTk0OiBFUlJPUjogZnVuY3Rpb24gdG9fY2hhcihudW1lcmljKSBkb2VzIG5vdCBl eGlzdAomZ3Q7Jmd0OwomZ3Q7Jmd0OyBUaGVyZSBpcyBubyBwcm9ibGVtIGJlZm9yZSB0aGUgdXBn cmFkZSBhbmQgdG9fY2hhcihudW1lcmljKSBmdW5jdGlvbiBjb21lcwomZ3Q7Jmd0OyBmcm9tIHRo ZSBPcmFmY2UgZXh0ZW5zaW9uLgomZ3Q7Jmd0OyBUaGUgY29uZmlndXJhdGlvbiBvZiB0aGUgb2xk IGFuZCBuZXcgZGF0YWJhc2VzIGlzIGFzIGZvbGxvd3MuCiZndDsmZ3Q7CiZndDsmZ3Q7IERhdGFi YXNlIHNlcnZlciAob2xkKTogUG9zdGdyZVNRTCAxMi4xMKOob3JhZmNlMy4xNaOpCiZndDsmZ3Q7 IERhdGFiYXNlIHNlcnZlciAobmV3KTogUG9zdGdyZVNRTCAxMi4xM6Oob3JhZmNlMy4yNKOpCiZn dDsmZ3Q7CiZndDsmZ3Q7IFRoZSBuZXcgZGF0YWJhc2UgaGFzIHN1Y2Nlc3NmdWxseSBpbnN0YWxs ZWQgdGhlIG9yYWZjZSAzLjI0IGV4dGVuc2lvbi4KJmd0OyZndDsgSXQgZG9lcyBub3Qgb2NjdXIg aW4gIlBvc3RncmVTUUwgMTIuMTAgYW5kIG9yYWZjZSAzLjE1IiwKJmd0OyZndDsgYnV0IG9jY3Vy cyBpbiAiUG9zdGdyZVNRTCAxMi4xMyBhbmQgb3JhZmNlIDMuMjQiLAomZ3Q7Jmd0OyBzbyBlaXRo ZXIgdGhlIGRpZmZlcmVuY2UgYmV0d2VlbiAxMi4xMCBhbmQgMTIuMTMgb3IgdGhlIGRpZmZlcmVu Y2UgYmV0d2VlbgomZ3Q7Jmd0OyBvcmFmY2UgMy4xNSBhbmQgMy4yNCBpcyBzdXNwaWNpb3VzLgom Z3Q7Jmd0OwomZ3Q7Jmd0OyBXaGF0IGlzIHRoZSByZWFzb24gZm9yIHRoZSBwcm9ibGVtPwomZ3Q7 CiZndDtvcmFmY2UgMy4yMiBtb3ZlZCBmdW5jdGlvbnMgdG8gc2NoZW1hIG9yYWNsZToKJmd0Owom Z3Q7aHR0cHM6Ly9naXRodWIuY29tL29yYWZjZS9vcmFmY2UvYmxvYi9iNDkyYTBmNTBkNWVlODY2 Yzk4NzBmODg2NDAxZDdjMzRhZDhjY2IzL05FV1MjTDQsTDUKJmd0O2h0dHBzOi8vZ2l0aHViLmNv bS9vcmFmY2Uvb3JhZmNlL2NvbW1pdC84NmExYjUxNDQwY2EzM2EwNGVmNDdmYzNiYjcwNGRlZTI2 ZDE2NzUzCiZndDsKJmd0Oy0tCiZndDtFcmlrCjwvcHJlPjwvZGl2Pg== ------=_Part_114450_43104944.1681923763535--