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 1tNW8G-000HV1-BV for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Dec 2024 11:52:57 +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 1tNW7H-001Hok-Kn for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Dec 2024 11:51:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tNW7G-001HoA-Mv for pgsql-bugs@lists.postgresql.org; Tue, 17 Dec 2024 11:51:55 +0000 Received: from mail-m16.yeah.net ([1.95.21.15]) by magus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tNW7A-00097h-U2 for pgsql-bugs@postgresql.org; Tue, 17 Dec 2024 11:51:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yeah.net; s=s110527; h=Date:From:Subject:Content-Type:MIME-Version: Message-ID; bh=GBVp29pw9VQGjOZaKATIGVgMgEdft+AwsXZJoACiLH8=; b=j 7fLi21r2Y1Ro1/6tczM1is7u5qqqENIIJLaoATDX1tTk2NrK6BALKhKEqr5ollcU rbTmDxfiRx69TGayn6k8F1r3EylCK4HcwAeEHIPyZ7hG1+y8VmiXAvMZNq6WjVTO 4vBzfJQ8vk28jEzQlV4QQOWFAIQtlB6Xs2VieWtLw4= Received: from zhenmingyang$yeah.net ( [123.113.180.177] ) by ajax-webmail-wmsvr-207-61 (Coremail) ; Tue, 17 Dec 2024 19:51:44 +0800 (CST) X-Originating-IP: [123.113.180.177] Date: Tue, 17 Dec 2024 19:51:44 +0800 (CST) X-CM-HeaderCharset: UTF-8 From: myzhen To: pgsql-bugs@postgresql.org Subject: to_timestamp function calculation error X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.14 build 20240801(9da12a7b) Copyright (c) 2002-2024 www.mailtech.cn yeah X-NTES-SC: AL_Qu2YBviYuUsr4iWQYOkXmUYbgOY5XMK4uv4v3INQOps0tSryxDw7c3pNFFfazsyDGzGjtR2UfhZ12Np4W4x8WJtQIBi1jPryJg3ioLD8Qoh+ Content-Type: multipart/alternative; boundary="----=_Part_24103_36500713.1734436304595" MIME-Version: 1.0 Message-ID: <4833ac30.18d0.193d475b6d3.Coremail.zhenmingyang@yeah.net> X-Coremail-Locale: zh_CN X-CM-TRANSID: Pc8vCgD3PyHQZWFnjsMHAA--.2703W X-CM-SenderInfo: x2kh0z5lqj5t1qj65vtdko0vbw/1tbiAg23-WdgEWDpIgAJsx X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_24103_36500713.1734436304595 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 V2hlbiBjYWxsaW5nIHRoZSB0b190aW1lc3RhbXAgZnVuY3Rpb24sIGlmIHRoZSBhY3R1YWwgcGFy YW1ldGVyIHBhc3NlZCBpcyBhIG5lZ2F0aXZlIHllYXIgYW5kIHlvdSBzcGVjaWZ5IEJDLCB0aGlz IHdpbGwgY2F1c2UgdG9fdGltZXN0YW1wIHRvIHJldHVybiBhbiBBRCBkYXRlLgpleGFtcGxl77ya c2VsZWN0IHRvX3RpbWVzdGFtcCgnLTIwMTEtMi0xOCAxNToxMzoxNCBCQycsICdZWVlZLU1NLURE IEhIMjQ6TUk6U1MgQkMnKTsKSSB0ZXN0ZWQgaXMgYXMgZm9sbG93czoKcG9zdGdyZXM9IyBzZWxl Y3QgdG9fdGltZXN0YW1wKCctMjAxMS0yLTE4IDE1OjEzOjE0JywgJ1lZWVktTU0tREQgSEgyNDpN STpTUyBCQycpOwogICAgICAgICAgdG9fdGltZXN0YW1wICAgICAgICAgICAKLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tCiAyMDExLTAyLTE4IDE1OjEzOjE0KzA4OjA1OjQzIEJDCigx IHJvdykKCgpwb3N0Z3Jlcz0jIHNlbGVjdCB0b190aW1lc3RhbXAoJy0yMDExLTItMTggMTU6MTM6 MTQgQkMnLCAnWVlZWS1NTS1ERCBISDI0Ok1JOlNTIEJDJyk7CiAgICAgIHRvX3RpbWVzdGFtcCAg ICAgIAotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KIDIwMTEtMDItMTggMTU6MTM6MTQrMDgKKDEg cm93KQoKCnBvc3RncmVzPSMgc2VsZWN0IHRvX3RpbWVzdGFtcCgnLTIwMTEtMi0xOCAxNToxMzox NCBCQycsICdZWVlZLU1NLUREIEhIMjQ6TUk6U1MgQkMnKSA9IHRvX3RpbWVzdGFtcCgnMjAxMS0y LTE4IDE1OjEzOjE0JywgJ1lZWVktTU0tREQgSEgyNDpNSTpTUycpOwogP2NvbHVtbj8gCi0tLS0t LS0tLS0KIHQKKDEgcm93KQoKCnBvc3RncmVzPSMKCgpJIGZvdW5kIHRoZSBmb2xsb3dpbmcgY29k ZSBzbmlwcGV0IGluIGRvX3RvX3RpbWVzdGFtcCBmdW5jdGlvbjoKewovKiBJZiBhIDQtZGlnaXQg eWVhciBpcyBwcm92aWRlZCwgd2UgdXNlIHRoYXQgYW5kIGlnbm9yZSBDQy4gKi8KdG0tPnRtX3ll YXIgPSB0bWZjLnllYXI7CmlmICh0bWZjLmJjKQp0bS0+dG1feWVhciA9IC10bS0+dG1feWVhcjsK LyogY29ycmVjdCBmb3Igb3VyIHJlcHJlc2VudGF0aW9uIG9mIEJDIHllYXJzICovCmlmICh0bS0+ dG1feWVhciA8IDApCnRtLT50bV95ZWFyKys7Cn0KQXMgbG9uZyBhcyB0bWZjLmJjIGlzIHRydWUs IHRtLT50bV95ZWFyID0gdG0tPnRtX3llYXIgKiAtMSwgdGhhdCdzIHdoYXQgbGVkIHRvIHRoaXMg c2NlbmUuCkkgaGF2ZW4ndCB0ZXN0ZWQgb24gb3RoZXIgREJNUyBzbyBJJ20gbm90IHN1cmUgaWYg dGhhdCdzIGFuIGlzc3VlLgogICAgICAgIEJlc3QgcmVnYXJkcw== ------=_Part_24103_36500713.1734436304595 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBkYXRhLW50ZXM9Im50ZXNfbWFpbF9ib2R5X3Jvb3QiIHN0eWxlPSJsaW5lLWhlaWdodDox Ljc7Y29sb3I6IzAwMDAwMDtmb250LXNpemU6MTRweDtmb250LWZhbWlseTpBcmlhbCI+PGRpdj5X aGVuIGNhbGxpbmcgdGhlIHRvX3RpbWVzdGFtcCBmdW5jdGlvbiwgaWYgdGhlIGFjdHVhbCBwYXJh bWV0ZXIgcGFzc2VkIGlzIGEgbmVnYXRpdmUgeWVhciBhbmQgeW91IHNwZWNpZnkgQkMsIHRoaXMg d2lsbCBjYXVzZSB0b190aW1lc3RhbXAgdG8gcmV0dXJuIGFuIEFEIGRhdGUuPC9kaXY+PGRpdj5l eGFtcGxl77yac2VsZWN0IHRvX3RpbWVzdGFtcCgnPGI+LTIwMTE8L2I+LTItMTggMTU6MTM6MTQ8 Yj4gQkM8L2I+JywgJ1lZWVktTU0tREQgSEgyNDpNSTpTUyBCQycpOzwvZGl2PjxkaXY+SSB0ZXN0 ZWQgaXMgYXMgZm9sbG93czo8L2Rpdj48ZGl2PjxkaXY+cG9zdGdyZXM9IyBzZWxlY3QgdG9fdGlt ZXN0YW1wKCctMjAxMS0yLTE4IDE1OjEzOjE0JywgJ1lZWVktTU0tREQgSEgyNDpNSTpTUyBCQycp OzwvZGl2PjxkaXY+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyB0b190aW1lc3Rh bXAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOzwvZGl2PjxkaXY+LS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPC9kaXY+PGRpdj4mbmJzcDsyMDExLTAyLTE4 IDE1OjEzOjE0KzA4OjA1OjQzIEJDPC9kaXY+PGRpdj4oMSByb3cpPC9kaXY+PGRpdj48YnI+PC9k aXY+PGRpdj5wb3N0Z3Jlcz0jIHNlbGVjdCB0b190aW1lc3RhbXAoJy0yMDExLTItMTggMTU6MTM6 MTQgPGI+QkM8L2I+JywgJ1lZWVktTU0tREQgSEgyNDpNSTpTUyBCQycpOzwvZGl2PjxkaXY+Jm5i c3A7ICZuYnNwOyAmbmJzcDsgdG9fdGltZXN0YW1wJm5ic3A7ICZuYnNwOyAmbmJzcDsmbmJzcDs8 L2Rpdj48ZGl2Pi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTwvZGl2PjxkaXY+Jm5ic3A7MjAxMS0w Mi0xOCAxNToxMzoxNCswODwvZGl2PjxkaXY+KDEgcm93KTwvZGl2PjxkaXY+PGJyPjwvZGl2Pjxk aXY+cG9zdGdyZXM9IyBzZWxlY3QgdG9fdGltZXN0YW1wKCctMjAxMS0yLTE4IDE1OjEzOjE0IEJD JywgJ1lZWVktTU0tREQgSEgyNDpNSTpTUyBCQycpID0gdG9fdGltZXN0YW1wKCcyMDExLTItMTgg MTU6MTM6MTQnLCAnWVlZWS1NTS1ERCBISDI0Ok1JOlNTJyk7PC9kaXY+PGRpdj4mbmJzcDs/Y29s dW1uPyZuYnNwOzwvZGl2PjxkaXY+LS0tLS0tLS0tLTwvZGl2PjxkaXY+Jm5ic3A7dDwvZGl2Pjxk aXY+KDEgcm93KTwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+cG9zdGdyZXM9IzwvZGl2PjwvZGl2 PjxkaXY+PGJyPjwvZGl2PjxkaXY+SSBmb3VuZCB0aGUgZm9sbG93aW5nIGNvZGUgc25pcHBldCBp biBkb190b190aW1lc3RhbXAgZnVuY3Rpb246PC9kaXY+PGRpdj48ZGl2PjxzcGFuIHN0eWxlPSJ3 aGl0ZS1zcGFjZTogbm9ybWFsOyI+PHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+CQk8L3Nw YW4+ezwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTogbm9ybWFsOyI+ PHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+CQkJPC9zcGFuPi8qIElmIGEgNC1kaWdpdCB5 ZWFyIGlzIHByb3ZpZGVkLCB3ZSB1c2UgdGhhdCBhbmQgaWdub3JlIENDLiAqLzwvc3Bhbj48L2Rp dj48ZGl2PjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTogbm9ybWFsOyI+PHNwYW4gc3R5bGU9Indo aXRlLXNwYWNlOnByZSI+CQkJPC9zcGFuPnRtLSZndDt0bV95ZWFyID0gdG1mYy55ZWFyOzwvc3Bh bj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTogbm9ybWFsOyI+PHNwYW4gc3R5 bGU9IndoaXRlLXNwYWNlOnByZSI+CQkJPC9zcGFuPmlmICh0bWZjLmJjKTwvc3Bhbj48L2Rpdj48 ZGl2PjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTogbm9ybWFsOyI+PHNwYW4gc3R5bGU9IndoaXRl LXNwYWNlOnByZSI+CQkJCTwvc3Bhbj50bS0mZ3Q7dG1feWVhciA9IC10bS0mZ3Q7dG1feWVhcjs8 L3NwYW4+PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6IG5vcm1hbDsiPjxzcGFu IHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUiPgkJCTwvc3Bhbj4vKiBjb3JyZWN0IGZvciBvdXIgcmVw cmVzZW50YXRpb24gb2YgQkMgeWVhcnMgKi88L3NwYW4+PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0i d2hpdGUtc3BhY2U6IG5vcm1hbDsiPjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUiPgkJCTwv c3Bhbj5pZiAodG0tJmd0O3RtX3llYXIgJmx0OyAwKTwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuIHN0 eWxlPSJ3aGl0ZS1zcGFjZTogbm9ybWFsOyI+PHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+ CQkJCTwvc3Bhbj50bS0mZ3Q7dG1feWVhcisrOzwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxl PSJ3aGl0ZS1zcGFjZTogbm9ybWFsOyI+PHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOnByZSI+CQk8 L3NwYW4+fTwvc3Bhbj48L2Rpdj48L2Rpdj48ZGl2PkFzIGxvbmcgYXMgdG1mYy5iYyBpcyB0cnVl LCB0bS0mZ3Q7dG1feWVhciA9IHRtLSZndDt0bV95ZWFyICogLTEsIHRoYXQncyB3aGF0IGxlZCB0 byB0aGlzIHNjZW5lLjwvZGl2PjxkaXY+SSBoYXZlbid0IHRlc3RlZCBvbiBvdGhlciBEQk1TIHNv IEknbSBub3Qgc3VyZSBpZiB0aGF0J3MgYW4gaXNzdWUuPC9kaXY+PGRpdj4mbmJzcDsgJm5ic3A7 ICZuYnNwOyAmbmJzcDsgPHNwYW4gc3R5bGU9ImNvbG9yOiByZ2IoNTEsIDUxLCA1MSk7IGZvbnQt ZmFtaWx5OiAmcXVvdDtQaW5nRmFuZyBTQyZxdW90OywgQXJpYWwsIEhlbHZldGljYSwgc2Fucy1z ZXJpZjsgZm9udC13ZWlnaHQ6IHZhcigtLWNvcy1mb250LW1lZGl1bSk7Ij5CZXN0IHJlZ2FyZHM8 L3NwYW4+PC9kaXY+PC9kaXY+ ------=_Part_24103_36500713.1734436304595--