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 1uyBgM-004tpw-J5 for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Sep 2025 16:03:59 +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 1uyBgK-00CIsE-7m for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Sep 2025 16:03:57 +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 1uyBgJ-00CIs5-TM for pgsql-bugs@lists.postgresql.org; Mon, 15 Sep 2025 16:03:56 +0000 Received: from m16.mail.163.com ([220.197.31.5]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uyBgE-000ZH1-0I for pgsql-bugs@lists.postgresql.org; Mon, 15 Sep 2025 16:03:54 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Date:From:To:Subject:Content-Type:MIME-Version: Message-ID; bh=tS4WPtAq+PfzLHQTm44n1IDqwFae5CJhXACFStLMkc0=; b=E LNwfFZTZ+h39p+Ac2ovjiDf55UXJvFw4BW1vDbGHxz4OEy2Lh4AxwWFgdankQo9Q dRTrz9rOmDEHdgs5ATfM/6Ghixx4qAFh23mCG5a8/9CQT1++mkPQPua+yGeJXL6b Rd7zWKz83XXTqYeRRmC+a0uQAYISK7NQajbO/epsa4= Received: from ocean_li_996$163.com ( [121.199.22.223] ) by ajax-webmail-wmsvr-40-126 (Coremail) ; Tue, 16 Sep 2025 00:03:42 +0800 (CST) X-Originating-IP: [121.199.22.223] Date: Tue, 16 Sep 2025 00:03:42 +0800 (CST) From: ocean_li_996 To: "jbe-mlist@magnetkern.de " , "pgsql-bugs@lists.postgresql.org " Subject: Re:BUG #19053: Inconsistent arithmetic regarding TIMESTAMPTZ and INTERVAL X-Priority: 3 X-Mailer: Coremail Webmail Server Version 2023.4-cmXT build 20250723(a044bf12) Copyright (c) 2002-2025 www.mailtech.cn 163com In-Reply-To: <19053-669df0ccf3d14d52@postgresql.org> References: <19053-669df0ccf3d14d52@postgresql.org> X-NTES-SC: AL_Qu2eBfWevUop5COfZ+kfmUoVhOc5Xsq4uPgu3IdQPJB6jA3pyhgBRVFtHVra8fqxEBmCiQC4XhJK1OtCRqR/W5IgsEElf6sw+LD37ZfzYquBPw== Content-Type: multipart/alternative; boundary="----=_Part_184670_1175205517.1757952222385" MIME-Version: 1.0 Message-ID: <2601954f.8be.1994e1e24b2.Coremail.ocean_li_996@163.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: figvCgD3f0LeOMhoFHIDAA--.3256W X-CM-SenderInfo: prfht05bolsmizw6il2tof0z/1tbiFAzJj2jH56sMMQAGsG X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_184670_1175205517.1757952222385 Content-Type: text/plain; charset=gbk Content-Transfer-Encoding: base64 SGVsbG8sCkkgdGhpbmsgdGhpcyBpcyBjYXVzZWQgYnkgdGhlIGRheWxpZ2h0IHNhdmluZyB0aW1l IGFuZCBzdGFuZGFyZCB0aW1lIGNoYW5nZXMgaW4gdGhlIEV1cm9wZS9CZXJsaW4gdGltZXpvbmUu IApJdCBpcyBub3QgYSBidWcsIGJ1dCB0aGUgZXhwZWN0ZWQgYmVoYXZpb3IuIEluIDIwMjUsIGRh eWxpZ2h0IHNhdmluZyB0aW1lIHN0YXJ0cyBhdCAnMjAyNS0wMy0zMCAwMTowMCBVVEMnIAphbmQg ZW5kcyBhdCAnMjAyNS0xMC0yNiAwMTowMCBVVEMnLiBXaGVuIGNoYW5naW5nLCBpdCB3aWxsIG1h a2Ugb25lIGhvdXIgZ2FwLiAKCgotLQoKcmVnYXJkcwpIYWl5YW5nIExpCgo= ------=_Part_184670_1175205517.1757952222385 Content-Type: text/html; charset=gbk Content-Transfer-Encoding: base64 SGVsbG8sPGRpdj5JIHRoaW5rIHRoaXMgaXMgY2F1c2VkIGJ5IHRoZSBkYXlsaWdodCBzYXZpbmcg dGltZSBhbmQgc3RhbmRhcmQgdGltZSBjaGFuZ2VzIGluIHRoZSBFdXJvcGUvQmVybGluIHRpbWV6 b25lLiZuYnNwOzwvZGl2PjxkaXY+SXQgaXMgbm90IGEgYnVnLCBidXQgdGhlIGV4cGVjdGVkIGJl aGF2aW9yLiBJbiAyMDI1LCBkYXlsaWdodCBzYXZpbmcgdGltZSBzdGFydHMgYXQgJzIwMjUtMDMt MzAgMDE6MDAgVVRDJyZuYnNwOzwvZGl2PjxkaXY+YW5kIGVuZHMgYXQgJzIwMjUtMTAtMjYgMDE6 MDAgVVRDJy4gV2hlbiBjaGFuZ2luZywgaXQgd2lsbCBtYWtlIG9uZSBob3VyIGdhcC4mbmJzcDs8 L2Rpdj48ZGl2Pjxicj48ZGl2IGlkPSJzcG5FZGl0b3JTaWduX2FwcCI+LS08YnI+PC9kaXY+PGRp diBpZD0ic3BuRWRpdG9yU2lnbl9hcHAiPnJlZ2FyZHM8L2Rpdj48ZGl2IGlkPSJzcG5FZGl0b3JT aWduX2FwcCI+SGFpeWFuZyBMaTwvZGl2Pjxicj48L2Rpdj4= ------=_Part_184670_1175205517.1757952222385--