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 1rTMBh-002HSJ-AJ for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Jan 2024 13:24:05 +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 1rTMBg-00Fcxi-8Q for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Jan 2024 13:24:04 +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 1rTLvI-00FOa6-Oo for pgsql-bugs@lists.postgresql.org; Fri, 26 Jan 2024 13:07: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.94.2) (envelope-from ) id 1rTLvG-003TTo-7q for pgsql-bugs@lists.postgresql.org; Fri, 26 Jan 2024 13:07:07 +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=xrOOiRhbssnM4a2iEM/icYVMfzUBIazA5CyRNt4Z+dY=; b=6+ZO76aK90BxRWsOfSfzsFiI92 Y8Xm6vTtG0l+pdoXUQ/3eAZ57cOk5VCDSt167lo1WKbOHRi/4jfG0DWITFbvc3xBMsD/dXbmJUFAN E3fHo2XAMO5LuQjf7MHYBVvG4Q+cyEkPRry7Gk64+exRuBXh+d5ft7duokJDf9u5Qs27Zj+DK6Ia5 /hJZL1AkpKvw4KX18uzV0P3j7IteGlbkd9S/4oYBPN8SiDpg7SAKCsSw0RNgZCRMM/hl2z4gbTz0t bUPv/xtXTEjyEbtWD5u7o1EdkuE4vZuawdpFgrfQRvRPNXcrFB23V4SsbJoyB2EMxLAavVEO/31ja wQk543Wg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rTLvF-00AWDw-2D for pgsql-bugs@lists.postgresql.org; Fri, 26 Jan 2024 13:07:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rTLvC-006oD9-N4 for pgsql-bugs@lists.postgresql.org; Fri, 26 Jan 2024 13:07:02 +0000 Content-Type: multipart/mixed; boundary="===============5697608161311673602==" MIME-Version: 1.0 Subject: BUG #18313: No error triggered when subtracting an interval from a timestamp To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: c.maurer@gmx.at Reply-To: c.maurer@gmx.at, pgsql-bugs@lists.postgresql.org Date: Fri, 26 Jan 2024 13:06:03 +0000 Message-ID: <18313-64d2c8952d81e84b@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 --===============5697608161311673602== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODMxMwpMb2dnZWQgYnk6ICAgICAgICAgIENocmlzdGlhbiBNYXVyZXIK RW1haWwgYWRkcmVzczogICAgICBjLm1hdXJlckBnbXguYXQKUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ni4xCk9wZXJhdGluZyBzeXN0ZW06ICAgUkhFTCA5CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaQ0K DQpUaGUgU1FMIHNjcmlwdCBiZWxvdyB1c2VzIGFuIGFuY2hvciBkYXRlICgyMDAwLTAxLTAxKSBp biBhIHRhYmxlIGFuZCB0cmllcwp0byBzdWJ0cmFjdCBhbiBpbnRlcnZhbCAoaW4gZGF5cykgZnJv bSBpdC4NCkNvbnNpZGVyaW5nIHRoZSB0aW1lc3RhbXAgcmFuZ2UsIHRoZSBtYXhpbXVtIG51bWJl ciBvZiBkYXlzIHRoYXQgY2FuIGJlCnN1Y2Nlc3NmdWxseSBzdWJ0cmFjdGVkIHNob3VsZCBiZSAy NDUxNTQ1LiBBbGwgaGlnaGVyIHZhbHVlcyBhcmUgdGhlbgpleHBlY3RlZCB0byB0cmlnZ2VyIGFu IGV4Y2VwdGlvbi4NCg0KSG93ZXZlciwgd2hlbiBzdWJ0cmFjdGluZyAyNDgzNTkwLCBubyBlcnJv ciBpcyB0cmlnZ2VyZWQuIFRoaXMgaXMgdHJ1ZSB1cCB0bwoyNTM5NzM4Lg0KU3VidHJhY3Rpbmcg MjUzOTczOSBhZ2FpbiBzaG93cyBhbiBlcnJvciBtZXNzYWdlLg0KDQpJcyB0aGlzIHRoZSBpbnRl bmRlZCBiZWhhdmlvcj8NCg0KUGxhdGZvcm06IFdlIHVzZSBQb3N0Z3JlU1FMIDE2LjEgKFBHREcp IHVuZGVyIFJlZCBIYXQgRW50ZXJwcmlzZSBMaW51eCA5CndpdGggc3RhbmRhcmQgc2V0dGluZ3Mu DQoNClJlZ2FyZHMsDQpDaHJpc3RpYW4NCg0KY3JlYXRlIHRhYmxlIHRibF90aW1lc3RhbXBfbGlt aXQgKGFuY2hvcl9kYXRlIFRJTUVTVEFNUCg2KSwgb2Zmc2V0X3ZhbHVlCkJJR0lOVCk7DQppbnNl cnQgaW50byB0YmxfdGltZXN0YW1wX2xpbWl0IChhbmNob3JfZGF0ZSkgdmFsdWVzCih0b190aW1l c3RhbXAoJzIwMDAwMTAxJywnWVlZWU1NREQnKSk7DQoNCi0tIHRoZSBtYXhpbXVtIHZhbHVlIGlu IGRheXMgd2UgY2FuIHN1YnRyYWN0IGZyb20gJzIwMDAtMDEtMDEnIHdpdGhvdXQgYW4KZXJyb3Ig aXMgMjQ1MTU0NQ0KdXBkYXRlIHRibF90aW1lc3RhbXBfbGltaXQgc2V0IG9mZnNldF92YWx1ZT0y NDgzNTg5Ow0KLS0gMjQ4MzU4OSBmYWlscyBhcyBleHBlY3RlZA0KU0VMRUNUIChhbmNob3JfZGF0 ZSAtIElOVEVSVkFMICcxIGRheScgKiAob2Zmc2V0X3ZhbHVlKSkgRlJPTQp0YmxfdGltZXN0YW1w X2xpbWl0Ow0KDQotLSBvbmUgZGF5IG1vcmUNCnVwZGF0ZSB0YmxfdGltZXN0YW1wX2xpbWl0IHNl dCBvZmZzZXRfdmFsdWU9MjQ4MzU5MDsNCi0tIDI0ODM1OTAgc3VycHJpc2luZ2x5IHN1Y2NlZWRz LCBubyBlcnJvciBpcyB0cmlnZ2VyZWQNClNFTEVDVCAoYW5jaG9yX2RhdGUgLSBJTlRFUlZBTCAn MSBkYXknICogKG9mZnNldF92YWx1ZSkpIEZST00KdGJsX3RpbWVzdGFtcF9saW1pdDsNCg0KdXBk YXRlIHRibF90aW1lc3RhbXBfbGltaXQgc2V0IG9mZnNldF92YWx1ZT0yNTM5NzM4Ow0KLS0gMjUz OTczOCBzdGlsbCBkb2VzIG5vdCB0cmlnZ2VyIGFuIGVycm9yDQpTRUxFQ1QgKGFuY2hvcl9kYXRl IC0gSU5URVJWQUwgJzEgZGF5JyAqIChvZmZzZXRfdmFsdWUpKSBGUk9NCnRibF90aW1lc3RhbXBf bGltaXQ7DQoNCnVwZGF0ZSB0YmxfdGltZXN0YW1wX2xpbWl0IHNldCBvZmZzZXRfdmFsdWU9MjUz OTczOTsNCi0tIDI1Mzk3MzkgZmFpbHMgYXMgZXhwZWN0ZWQNClNFTEVDVCAoYW5jaG9yX2RhdGUg LSBJTlRFUlZBTCAnMSBkYXknICogKG9mZnNldF92YWx1ZSkpIEZST00KdGJsX3RpbWVzdGFtcF9s aW1pdDsKCg== --===============5697608161311673602==--