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 1uy6Ik-003wTF-VH for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Sep 2025 10:19:15 +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 1uy6Ii-00B8EW-Qq for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Sep 2025 10:19:13 +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 1uy6Cq-00B3Ok-HP for pgsql-bugs@lists.postgresql.org; Mon, 15 Sep 2025 10:13:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uy6Co-000WbT-08 for pgsql-bugs@lists.postgresql.org; Mon, 15 Sep 2025 10:13:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=1kvYPq8XcY5EesaOz6oEBf2aBbfzkb0PFUka/BG/GY0=; b=2sd+htwcyJxA/uttZ7+Du/ZyEN q5Yi+eZxv+hoLZDlIWWV8nkvG+IkUnDD1BnEiRY5o+a6xah3pf3s3+oVql3oQdUbpMTawsNGJJqiF wdxbqzrkGpPf76o/ohGkukV0ORfSNfOz/t5pncKFwA4I5e0ovhQUJrwCWhb5HSFqt2+gENRFRMBnB 5B1U9k5BvxZgZhNglLmMhc/ive+XNyqv/ehV4gZXyIXiZAG336h1NbHKJRp1tpLbX20KqtxXQIPO8 zuXc+OrGchUYrYNP1EtxWS8ySAQ8X35jRcXLGIS1tn7QFDrkKfjEcg+k/W++tFSG11KZoq0Ona2Mw QE8VTn2Q==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uy6Cn-001Qmu-0H for pgsql-bugs@lists.postgresql.org; Mon, 15 Sep 2025 10:13:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uy6Ck-002lBU-3C for pgsql-bugs@lists.postgresql.org; Mon, 15 Sep 2025 10:13:03 +0000 Content-Type: multipart/mixed; boundary="===============8735437010708447459==" MIME-Version: 1.0 Subject: BUG #19053: Inconsistent arithmetic regarding TIMESTAMPTZ and INTERVAL To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jbe-mlist@magnetkern.de Reply-To: jbe-mlist@magnetkern.de, pgsql-bugs@lists.postgresql.org Date: Mon, 15 Sep 2025 10:12:58 +0000 Message-ID: <19053-669df0ccf3d14d52@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8735437010708447459== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA1MwpMb2dnZWQgYnk6ICAgICAgICAgIEphbiBCZWhyZW5zCkVtYWls IGFkZHJlc3M6ICAgICAgamJlLW1saXN0QG1hZ25ldGtlcm4uZGUKUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNy41Ck9wZXJhdGluZyBzeXN0ZW06ICAgRnJlZUJTRApEZXNjcmlwdGlvbjogICAgICAgIAoK Q29uc2lkZXIgdGhlIGZvbGxvd2luZyBjYWxjdWxhdGlvbnM6CgpqYmU9IyBTRVQgVElNRSBaT05F ICdFdXJvcGUvQmVybGluJzsKU0VUCmpiZT0jIFNFTEVDVCBUSU1FU1RBTVBUWiAnMjAyNS0xMC0y NycgLSBUSU1FU1RBTVBUWiAnMjAyNS0xMC0yNic7CiAgICA/Y29sdW1uPwotLS0tLS0tLS0tLS0t LS0tCiAxIGRheSAwMTowMDowMAooMSByb3cpCgpqYmU9IyBTRUxFQ1QgVElNRVNUQU1QVFogJzIw MjUtMTAtMjYnICsgSU5URVJWQUwgJzEgZGF5IDAxOjAwOjAwJzsgLS0gdGhlCmZvbGxvd2luZyBy ZXN1bHQgaXMgc3VycHJpc2luZywgYXMgaXQgaXMgbm90IG1pZG5pZ2h0CiAgICAgICAgP2NvbHVt bj8KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiAyMDI1LTEwLTI3IDAxOjAwOjAwKzAxCigxIHJv dykKCmpiZT0jIFNFTEVDVCBUSU1FU1RBTVBUWiAnMjAyNS0wMy0zMScgLSBUSU1FU1RBTVBUWiAn MjAyNS0wMy0zMCc7CiA/Y29sdW1uPwotLS0tLS0tLS0tCiAyMzowMDowMAooMSByb3cpCgpqYmU9 IyBTRUxFQ1QgVElNRVNUQU1QVFogJzIwMjUtMDMtMzAnICsgSU5URVJWQUwgJzIzOjAwOjAwJzsg LS0gaW5jb25zaXN0ZW50CndpdGggdGhlIHByZXZpb3VzIGFkZGl0aW9uIGFib3ZlLCBhcyBpdCBp cyBtaWRuaWdodAogICAgICAgID9jb2x1bW4/Ci0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogMjAy NS0wMy0zMSAwMDowMDowMCswMgooMSByb3cpCgpqYmU9IyBTRUxFQ1QgVElNRVNUQU1QVFogJzIw MjUtMDQtMDEnIC0gVElNRVNUQU1QVFogJzIwMjUtMDMtMzAnOwogICAgP2NvbHVtbj8KLS0tLS0t LS0tLS0tLS0tLQogMSBkYXkgMjM6MDA6MDAKKDEgcm93KQoKamJlPSMgU0VMRUNUIFRJTUVTVEFN UFRaICcyMDI1LTAzLTMwJyArIElOVEVSVkFMICcxIGRheSAyMzowMDowMCc7IC0tIGhlcmUsCnRo ZSByZXN1bHQgaXNuJ3QgbWlkbmlnaHQgYWdhaW4KICAgICAgICA/Y29sdW1uPwotLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0KIDIwMjUtMDMtMzEgMjM6MDA6MDArMDIKKDEgcm93KQoKT3IsIHNvbWUg b2YgdGhlc2Ugb3BlcmF0aW9ucyB3cml0dGVuIGluIGEgc2luZ2xlIGV4cHJlc3Npb246CgpqYmU9 IyBTRUxFQ1QgVElNRVNUQU1QVFogJzIwMjUtMDMtMzAnICsgKFRJTUVTVEFNUFRaICcyMDI1LTAz LTMxJyAtClRJTUVTVEFNUFRaICcyMDI1LTAzLTMwJyk7CiAgICAgICAgP2NvbHVtbj8KLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tCiAyMDI1LTAzLTMxIDAwOjAwOjAwKzAyCigxIHJvdykKCmpiZT0j IFNFTEVDVCBUSU1FU1RBTVBUWiAnMjAyNS0wMy0zMCcgKyAoVElNRVNUQU1QVFogJzIwMjUtMDQt MDEnIC0KVElNRVNUQU1QVFogJzIwMjUtMDMtMzAnKTsKICAgICAgICA/Y29sdW1uPwotLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0KIDIwMjUtMDMtMzEgMjM6MDA6MDArMDIKKDEgcm93KQoKTm90ZSB0 aGF0IHRoZXJlIGlzIG5vIHRpbWUgem9uZSBjaGFuZ2UgaW4gYmV0d2VlbiAyMDI1LTAzLTMxIGFu ZCAyMDI1LTA0LTAxLAp5ZXQgdGhlIHRpbWUgb2YgdGhlIHByZXZpb3VzIHR3byBjYWxjdWxhdGlv bnMgaXMgb2ZmIGJ5IG9uZSBob3VyLgoK --===============8735437010708447459==--