Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qWzyo-004sr0-3F for pgsql-bugs@arkaria.postgresql.org; Fri, 18 Aug 2023 13:57:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qWzym-00C6HQ-8x for pgsql-bugs@arkaria.postgresql.org; Fri, 18 Aug 2023 13:57:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qWzyl-00C6H7-8D for pgsql-bugs@lists.postgresql.org; Fri, 18 Aug 2023 13:57:32 +0000 Received: from m13123.mail.163.com ([220.181.13.123]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qWzyf-000or8-4X for pgsql-bugs@lists.postgresql.org; Fri, 18 Aug 2023 13:57:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Date:From:Subject:Content-Type:MIME-Version: Message-ID; bh=i0KMQOpfQFBD3rBhCdh4WAo0jdNuiluUN/QJafhEhQs=; b=F KVbixIpYjXf2g/qb3gPUeY8rpRlGV7GWRlMomwiqJdK74CmIZUFR2GhBN7Qv+L0q 8fDKwPvKEUKSrqiXaoUPsgQ5NwNZiGYSrLUbUedKFxVKPybU16uuOfl03qHOqeLf 7Ildv0iEy/a2Ckh+QFCI5laW6yWaJq+9DjpnyWKaRA= Received: from msdnchina$163.com ( [111.14.147.39] ) by ajax-webmail-wmsvr123 (Coremail) ; Fri, 18 Aug 2023 21:57:17 +0800 (CST) X-Originating-IP: [111.14.147.39] Date: Fri, 18 Aug 2023 21:57:17 +0800 (CST) From: "yanliang lei" To: "Bruce Momjian" Cc: "Tom Lane" , pgsql-bugs@lists.postgresql.org Subject: Re:Re: BUG #18034: Accept the spelling "+infinity" in datetime input is not accurate X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.14 build 20230109(dcb5de15) Copyright (c) 2002-2023 www.mailtech.cn 163com In-Reply-To: References: <18034-08e668401be826ed@postgresql.org> <26522.1691636007@sss.pgh.pa.us> X-NTES-SC: AL_QuySAP+duEgo4SGfYukXk0wbgOs5UMCwu/Uv3oJfP5E0nivk3w8GbG5MBln608SXJRGBoQmdbydq+/1mWoBHcpPiZXz+u9WSGEkcjsbzWIyK Content-Type: multipart/alternative; boundary="----=_Part_101267_261934221.1692367037181" MIME-Version: 1.0 Message-ID: <3f714db4.6b78.18a08efa2fd.Coremail.msdnchina@163.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: e8GowACnxsa+eN9k9GkEAA--.21713W X-CM-SenderInfo: xpvg0upklqtqqrwthudrp/1tbiWx7Pg2I0bTuegwAAsU X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_101267_261934221.1692367037181 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 RGVhciBldmVyeW9uZaOsCkkgcmFpc2UgdGhpcyBxdWVzdGlvbiBiYXNlZCBvbiB0aGUgZm9sbG93 aW5nIGNvbnNpZGVyYXRpb25zOgoxLiBNYWtlIFBvc3RncmVTUUwgZWFzaWVyIGZvciBiZWdpbm5l cnMgdG8gbGVhcm6juwoyLiBQb3N0Z3JlU1FMIGlzIGEgZGF0YWJhc2Ugc29mdHdhcmUgcHJvZHVj dCByYXRoZXIgdGhhbiBhIGRhdGFiYXNlIHNvZnR3YXJlIHByb2plY3QuIEEgcHJvZHVjdCBtZWFu cyBiZWluZyBtb3JlIHVzZXItZnJpZW5kbHksIHByZWNpc2UsIGFuZCByZWR1Y2luZyB0aGUgbGlr ZWxpaG9vZCBvZiBtaXN1bmRlcnN0YW5kaW5nc6GjCgoKVGhlIGRhdGV0aW1lIHR5cGUgbWF5IG1h a2UgYmVnaW5uZXJzIHRoaW5rIHRoYXQgdGhlcmUgaXMgYSBkYXRldGltZSBkYXRhIHR5cGUgaW4g dGhlIFBvc3RncmVTUUwgZGF0YWJhc2UuIEFsdGhvdWdoIHNlbmlvciBQb3N0Z3JlU1FMIHByb2Zl c3Npb25hbHMga25vdyB0aGF0IHRoZXJlIGlzIG5vIGRhdGV0aW1lIGRhdGEgdHlwZSwgdGhlIGRh dGV0aW1lIHR5cGUgaXMgZW5vdWdoIHRvIG1ha2UgYmVnaW5uZXJzIG1pc3VuZGVyc3RhbmQuCkhv d2V2ZXIsIFdoZW4gdGhleSBzYXcgdGhhdCB0aGUgUmVsZWFzZU5vdGUgaW4gUG9zdGdyZVNRTCAx NiByZWNvcmRlZCAiQWNjZXB0IHRoZSBzcGVsbGluZyIraW5maW5pdHkgImluIGRhdGV0aW1lIHR5 cGUgaW5wdXQio6wKIHRoZSB0ZXJtICdkYXRldGltZSB0eXBlJyBpcyBzdWZmaWNpZW50IGZvciBi ZWdpbm5lcnMgdG8gbWlzdW5kZXJzdGFuZCAsIHVubGVzcyBpdCBpcyBub3RlZCB0aGF0ICdkYXRl dGltZSB0eXBlJyBpcyBhIGdlbmVyYWwgdGVybSwgcmVwcmVzZW50aW5nIHRoZSBmb2xsb3dpbmcg UG9zdGdyZVNRTCBkYXRhIHR5cGVzOiB0aW1lc3RhbXAgWyhwKV0gW3dpdGhvdXQgdGltZSB6b25l XSwgdGltZXN0YW1wIFsocCldIHdpdGggdGltZSB6b25lLCBkYXRloaMKCgpJIGFtIG5vdCBuaXRw aWNraW5nIKOsSSBob3BlIHRoYXQ6IFBvc3RncmVTUUwgZGF0YWJhc2Ugc29mdHdhcmUgcHJvZHVj dHMgY2FuIGJlY29tZSBtb3JlIHBlcmZlY3QgYW5kIGFjY3VyYXRloaMKVGhhbmtzIGEgbG90o6EK CgoKCgoKCgoKCgoKCgoKCgoKCgoKCgpBdCAyMDIzLTA4LTEwIDE5OjI1OjUxLCAiQnJ1Y2UgTW9t amlhbiIgPGJydWNlQG1vbWppYW4udXM+IHdyb3RlOgo+T24gV2VkLCBBdWcgIDksIDIwMjMgYXQg MTA6NTM6MjdQTSAtMDQwMCwgVG9tIExhbmUgd3JvdGU6Cj4+IEJydWNlIE1vbWppYW4gPGJydWNl QG1vbWppYW4udXM+IHdyaXRlczoKPj4gPiBXZSBjYWxsIG91ciB0aW1lc3RhbXAgdHlwZSBkYXRl dGltZSBpbiBzb21lIGNhc2VzLCBlLmcuOgo+PiA+IC4uLgo+PiA+IEkgc2VlIGl0IGluIGEgZmV3 IG90aGVyIHBsYWNlcy4gIFNob3VsZCB3ZSByZW5hbWUgaXQgb3RoZXIgcGxhY2VzIHRvbz8gCj4+ ID4gSSB0aG91Z2h0IGRhdGV0aW1lIHdhcyBqdXN0IGEgc2hvcnQtaGFuZCBmb3Igb3VyIGRhdGUt dGltZSB0eXBlcy4KPj4gCj4+IEkgZG9uJ3Qgc2VlIG11Y2ggcmVhc29uIHRvIGNoYW5nZSBhbnl0 aGluZyBoZXJlLiAgIkRhdGV0aW1lIiBpcyBub3QKPj4gYSBwZXJmZWN0bHkgc3RyaWN0IGNsYXNz aWZpY2F0aW9uLCBlZyBpdCBtaWdodCBvciBtaWdodCBub3QgaW5jbHVkZQo+PiAiaW50ZXJ2YWwi IGRlcGVuZGluZyBvbiBjb250ZXh0LCBhbmQgSSBkb24ndCB3YW50IHRvIHRyeSB0byBtYWtlCj4+ IHRoYXQgZXhhY3QuCj4+IAo+PiBBIG1vcmUgc3BlY2lmaWMgcmVsZWFzZSBub3RlIGVudHJ5IGNv dWxkIGJlICJBY2NlcHQgdGhlIHNwZWxsaW5nCj4+ICcraW5maW5pdHknIGZvciBkYXRldGltZSB0 eXBlcyB0aGF0IGFjY2VwdCBpbmZpbml0eSI7IGJ1dCBJJ20gbm90Cj4+IHN1cmUgaXQncyB3b3J0 aCB0aGUgZXh0cmEgdmVyYmlhZ2UuCj4KPlllYWgsIHRoYXQgd2FzIG15IGFuYWx5c2lzIHRvby4K Pgo+LS0gCj4gIEJydWNlIE1vbWppYW4gIDxicnVjZUBtb21qaWFuLnVzPiAgICAgICAgaHR0cHM6 Ly9tb21qaWFuLnVzCj4gIEVEQiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg aHR0cHM6Ly9lbnRlcnByaXNlZGIuY29tCj4KPiAgT25seSB5b3UgY2FuIGRlY2lkZSB3aGF0IGlz IGltcG9ydGFudCB0byB5b3UuCg== ------=_Part_101267_261934221.1692367037181 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXY+RGVhciBldmVyeW9uZaOsPC9kaXY+PGRpdj5JIHJhaXNl IHRoaXMgcXVlc3Rpb24gYmFzZWQgb24gdGhlIGZvbGxvd2luZyBjb25zaWRlcmF0aW9uczo8YnI+ MS4gTWFrZSBQb3N0Z3JlU1FMIGVhc2llciBmb3IgYmVnaW5uZXJzIHRvIGxlYXJuo7s8YnI+Mi4g UG9zdGdyZVNRTCBpcyBhIGRhdGFiYXNlIHNvZnR3YXJlIDxiPnByb2R1Y3QgPC9iPnJhdGhlciB0 aGFuIGEgZGF0YWJhc2Ugc29mdHdhcmUgPGI+cHJvamVjdDwvYj4uIEEgcHJvZHVjdCBtZWFucyBi ZWluZyBtb3JlIHVzZXItZnJpZW5kbHksIHByZWNpc2UsIGFuZCByZWR1Y2luZyB0aGUgbGlrZWxp aG9vZCBvZiBtaXN1bmRlcnN0YW5kaW5nc6GjPGJyPjxicj48YnI+VGhlIGRhdGV0aW1lIHR5cGUg bWF5IG1ha2UgYmVnaW5uZXJzIHRoaW5rIHRoYXQgdGhlcmUgaXMgYSBkYXRldGltZSBkYXRhIHR5 cGUgaW4gdGhlIFBvc3RncmVTUUwgZGF0YWJhc2UuIEFsdGhvdWdoIHNlbmlvciBQb3N0Z3JlU1FM IHByb2Zlc3Npb25hbHMga25vdyB0aGF0IHRoZXJlIGlzIG5vIGRhdGV0aW1lIGRhdGEgdHlwZSwg dGhlIGRhdGV0aW1lIHR5cGUgaXMgZW5vdWdoIHRvIG1ha2UgYmVnaW5uZXJzIG1pc3VuZGVyc3Rh bmQuPC9kaXY+PGRpdj5Ib3dldmVyLCBXaGVuIHRoZXkgc2F3IHRoYXQgdGhlIFJlbGVhc2VOb3Rl IGluIFBvc3RncmVTUUwgMTYgcmVjb3JkZWQgIkFjY2VwdCB0aGUgc3BlbGxpbmciK2luZmluaXR5 ICJpbiBkYXRldGltZSB0eXBlIGlucHV0IqOsPC9kaXY+PGRpdj4mbmJzcDt0aGUgdGVybSAnZGF0 ZXRpbWUgdHlwZScgaXMgc3VmZmljaWVudCBmb3IgYmVnaW5uZXJzIHRvIAptaXN1bmRlcnN0YW5k ICwgdW5sZXNzIGl0IGlzIG5vdGVkIHRoYXQgJ2RhdGV0aW1lIHR5cGUnIGlzIGEgZ2VuZXJhbCAK dGVybSwgcmVwcmVzZW50aW5nIHRoZSBmb2xsb3dpbmcgUG9zdGdyZVNRTCBkYXRhIHR5cGVzOiB0 aW1lc3RhbXAgWyhwKV0gClt3aXRob3V0IHRpbWUgem9uZV0sIHRpbWVzdGFtcCBbKHApXSB3aXRo IHRpbWUgem9uZSwgZGF0ZaGjPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5JIGFtIG5vdCBuaXRw aWNraW5nIKOsSSBob3BlIHRoYXQ6IFBvc3RncmVTUUwgZGF0YWJhc2Ugc29mdHdhcmUgcHJvZHVj dHMgY2FuIGJlY29tZSBtb3JlIHBlcmZlY3QgYW5kIGFjY3VyYXRloaM8L2Rpdj48ZGl2PlRoYW5r cyBhIGxvdKOhPGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48 YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7 Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46 IDA7Ij48YnI+PC9wPjxkaXYgc3R5bGU9InBvc2l0aW9uOnJlbGF0aXZlO3pvb206MSI+PC9kaXY+ PGRpdiBpZD0iZGl2TmV0ZWFzZU1haWxDYXJkIj48L2Rpdj48cCBzdHlsZT0ibWFyZ2luOiAwOyI+ PGJyPjwvcD48cHJlPjxicj5BdCAyMDIzLTA4LTEwIDE5OjI1OjUxLCAiQnJ1Y2UgTW9tamlhbiIg Jmx0O2JydWNlQG1vbWppYW4udXMmZ3Q7IHdyb3RlOgomZ3Q7T24gV2VkLCBBdWcgIDksIDIwMjMg YXQgMTA6NTM6MjdQTSAtMDQwMCwgVG9tIExhbmUgd3JvdGU6CiZndDsmZ3Q7IEJydWNlIE1vbWpp YW4gJmx0O2JydWNlQG1vbWppYW4udXMmZ3Q7IHdyaXRlczoKJmd0OyZndDsgJmd0OyBXZSBjYWxs IG91ciB0aW1lc3RhbXAgdHlwZSBkYXRldGltZSBpbiBzb21lIGNhc2VzLCBlLmcuOgomZ3Q7Jmd0 OyAmZ3Q7IC4uLgomZ3Q7Jmd0OyAmZ3Q7IEkgc2VlIGl0IGluIGEgZmV3IG90aGVyIHBsYWNlcy4g IFNob3VsZCB3ZSByZW5hbWUgaXQgb3RoZXIgcGxhY2VzIHRvbz8gCiZndDsmZ3Q7ICZndDsgSSB0 aG91Z2h0IGRhdGV0aW1lIHdhcyBqdXN0IGEgc2hvcnQtaGFuZCBmb3Igb3VyIGRhdGUtdGltZSB0 eXBlcy4KJmd0OyZndDsgCiZndDsmZ3Q7IEkgZG9uJ3Qgc2VlIG11Y2ggcmVhc29uIHRvIGNoYW5n ZSBhbnl0aGluZyBoZXJlLiAgIkRhdGV0aW1lIiBpcyBub3QKJmd0OyZndDsgYSBwZXJmZWN0bHkg c3RyaWN0IGNsYXNzaWZpY2F0aW9uLCBlZyBpdCBtaWdodCBvciBtaWdodCBub3QgaW5jbHVkZQom Z3Q7Jmd0OyAiaW50ZXJ2YWwiIGRlcGVuZGluZyBvbiBjb250ZXh0LCBhbmQgSSBkb24ndCB3YW50 IHRvIHRyeSB0byBtYWtlCiZndDsmZ3Q7IHRoYXQgZXhhY3QuCiZndDsmZ3Q7IAomZ3Q7Jmd0OyBB IG1vcmUgc3BlY2lmaWMgcmVsZWFzZSBub3RlIGVudHJ5IGNvdWxkIGJlICJBY2NlcHQgdGhlIHNw ZWxsaW5nCiZndDsmZ3Q7ICcraW5maW5pdHknIGZvciBkYXRldGltZSB0eXBlcyB0aGF0IGFjY2Vw dCBpbmZpbml0eSI7IGJ1dCBJJ20gbm90CiZndDsmZ3Q7IHN1cmUgaXQncyB3b3J0aCB0aGUgZXh0 cmEgdmVyYmlhZ2UuCiZndDsKJmd0O1llYWgsIHRoYXQgd2FzIG15IGFuYWx5c2lzIHRvby4KJmd0 OwomZ3Q7LS0gCiZndDsgIEJydWNlIE1vbWppYW4gICZsdDticnVjZUBtb21qaWFuLnVzJmd0OyAg ICAgICAgaHR0cHM6Ly9tb21qaWFuLnVzCiZndDsgIEVEQiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgaHR0cHM6Ly9lbnRlcnByaXNlZGIuY29tCiZndDsKJmd0OyAgT25seSB5 b3UgY2FuIGRlY2lkZSB3aGF0IGlzIGltcG9ydGFudCB0byB5b3UuCjwvcHJlPjwvZGl2Pg== ------=_Part_101267_261934221.1692367037181--