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 1s4fIC-0006cn-7W for pgsql-bugs@arkaria.postgresql.org; Wed, 08 May 2024 11:17:00 +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 1s4fHC-0006Yc-9A for pgsql-bugs@arkaria.postgresql.org; Wed, 08 May 2024 11:15:58 +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 1s4T0I-005Tbx-MR for pgsql-bugs@lists.postgresql.org; Tue, 07 May 2024 22:09:44 +0000 Received: from mx0a-000e5c01.pphosted.com ([67.231.149.193]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4T0F-001w5u-Kh for pgsql-bugs@lists.postgresql.org; Tue, 07 May 2024 22:09:41 +0000 Received: from pps.filterd (m0097804.ppops.net [127.0.0.1]) by mx0b-000e5c01.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 447IXP9R028759; Tue, 7 May 2024 18:09:37 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=evernorth.com; h=from : to : cc : date : message-id : references : in-reply-to : content-type : content-transfer-encoding : mime-version : subject; s=pod011016231234; bh=8bT+JFcwojIp0eWtfJ+fnPq3bjMSYeB1lyCkm3Dgwzg=; b=hBukJp3f+up63N1cy50b6zkmckcZW4MhhW+dSjw+63qE1s4+DmTZLWvM+FZYK5syDnz4 MiEB/9xmw7/F9HQ1peFmiFa2QyCo1iZJGTsQwmZF4wFdT5hGhXtO3GHtA8QSXfv2xNN8 3S1RBJswtt619Oj/ucxTUPytpOGATDpeGgaQwTq+PX+ccyAKUc+d8gC+kvLHUnEGtKLc TnwucmcZtVD0VBwW9PCmRrDA6bVTUSUVNnKJF2buYy0+xfv0ea8oKeOFplMwHPKYpFXa Lie0R9r+XXhIDAc1+BlAnkcVauEGAv1mDXneXiSEptJjhAanaBjTunHFB9PrBnr29MWT +Q== Received: from express-scripts.com (mx0a-000e5c14.pphosted.com [148.163.133.209]) by mx0b-000e5c01.pphosted.com (PPS) with ESMTPS id 3xysghrmen-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Tue, 07 May 2024 18:09:37 -0400 Received: from m0206225.ppops.net (m0206225.ppops.net [127.0.0.1]) by pps.cigna (8.17.1.5/8.17.1.5) with ESMTP id 447M9aWn026729; Tue, 7 May 2024 17:09:36 -0500 Received: from pps.reinject (localhost [127.0.0.1]) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3xysfk8dgq-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Tue, 07 May 2024 17:09:36 -0500 Received: from m0206225.ppops.net (m0206225.ppops.net [127.0.0.1]) by pps.reinject (8.17.1.5/8.17.1.5) with ESMTP id 447M9aSP026722; Tue, 7 May 2024 17:09:36 -0500 Received: from eiaappxp0012.gid.prd.globalcore.com (lyncav03.cigna.com [170.48.19.151] (may be forged)) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3xysfk8dgh-2 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Tue, 07 May 2024 17:09:35 -0500 Received: from cvlappxp20760.internal.cigna.com (HELO PS2PW1012186.accounts.root.corp) ([10.36.52.93]) by EIAAPPXP0012.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 07 May 2024 22:09:34 +0000 Received: from PS2PW1012186.accounts.root.corp (10.221.225.154) by PS2PW1012186.accounts.root.corp (10.221.225.154) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.4; Tue, 7 May 2024 18:09:34 -0400 Received: from PS2PW1012186.accounts.root.corp ([fe80::ddfb:faf8:59ca:a8ec]) by PS2PW1012186.accounts.root.corp ([fe80::ddfb:faf8:59ca:a8ec%6]) with mapi id 15.02.1544.004; Tue, 7 May 2024 18:09:34 -0400 From: "Wetmore, Matthew (CTR)" To: Tom Lane CC: Francisco Olarte , Michael Bondarenko , "pgsql-bugs@lists.postgresql.org" , "dgrowleyml@gmail.com" , Peter Eisentraut Thread-Topic: [EXTERNAL] Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); Thread-Index: AQHaYNhvbpqIpX2FvEiJ2iUtEb58OrEOGMsAgABoIICAAHiWgIAAWOWAgABY3ICAAAiTAIADP9yAgAEIUQCAABSOAIANdiSAgGuFSgD//8R80A== Date: Tue, 7 May 2024 22:09:34 +0000 Message-ID: <2219fd69a3024149af5adc31e14b25d7@evernorth.com> References: <18348-b097a3587dfde8a4@postgresql.org> <3709307.1708201825@sss.pgh.pa.us> <3749306.1708222748@sss.pgh.pa.us> <222870.1708458150@sss.pgh.pa.us> <270582.1708462564@sss.pgh.pa.us> <166456.1715117228@sss.pgh.pa.us> In-Reply-To: <166456.1715117228@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.222.252.1] x-proofpoint-routing: 000e5c14 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-CFilter-Loop: Reflected Subject: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1039,Hydra:6.0.650,FMLib:17.11.176.26 definitions=2024-05-07_14,2024-05-06_02,2023-05-22_02 X-Proofpoint-GUID: g6puGvwTDPApB0128MehyIWqjuZF6upI X-Proofpoint-ORIG-GUID: g6puGvwTDPApB0128MehyIWqjuZF6upI X-Connecting-IP: 148.163.133.209 X-External-Mail: True X-Content-Length: 7945 X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1039,Hydra:6.0.650,FMLib:17.11.176.26 definitions=2024-05-07_14,2024-05-06_02,2023-05-22_02 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 malwarescore=0 impostorscore=0 phishscore=0 spamscore=0 adultscore=0 mlxscore=0 bulkscore=0 suspectscore=0 mlxlogscore=999 priorityscore=1501 lowpriorityscore=0 clxscore=1011 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2405010000 definitions=main-2405070155 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGV2aWxzIGFkdm9jYXRpbmcgaGVyZSwgZmVlbCBmcmVlIHRvIGlnbm9yZS4NCg0KSXMgdGhlcmUg YSByZWFsIG5lZWQgZm9yIGEgbmVnYXRpdmUgbW9udGg/ICBTb3VuZHMgbGlrZSBoaWdoIGxldmVs IHRoaXMgY291bGQgYmUgZGlzYXN0cm91cyBpZiBJIHNjcmV3IHVwIHRoZSBzeW50YXguIChBaCwg bWVtb3JpZXMgb2YgREQpDQoNCkkgaGF2ZSBkb25lIHRoaXMgaW4gZGF0YSB3YXJlaG91c2luZyB3 aXRoIGRpbWVuc2lvbnMgdGFibGVzLg0KDQpKdXN0IHByb2Nlc3Mgb24gdGhlIElOVCBhbmQgdHJh bnNsYXRlIGludG8gdGhlIG5hbWUuDQoNCkkgd2FzIHRoaW5raW5nIG9uIGhvdyBhIG5lZ2F0aXZl IG1vbnRoIGNvdWxkIGltcGFjdCB0aGlzIHNpZGUgKGRhdGEgd2FyZWhvdXNpbmcpIHNpZGUgb2Yg cXVlcnlpbmcuIA0KDQpJIGNvdWxkIGJlIGNoaWNrZW4gbGl0dGxlIG9uIHRoaXMsIGJ1dCB3YW50 ZWQgaXQgaW4gdGhlIGNvbnZlcnNhdGlvbi4NCg0Kd29ya2Fyb3VuZCBmb3IgbmVnYXRpdmUgbW9u dGhzOg0KDQpDUkVBVEUgVEFCTEUgZGltX2Jpel9ob3VycyggeWVhciBJTlQoNCkNCiwgZG95IElO VCgzKQ0KLCBkb3cgSU5UKDcpDQosIG1vbnRoIElOVCgyKQ0KLCBkYXkgSU5UKDIpDQosIGhvdXIg SU5UKDIpDQosIG1pbnV0ZSBJTlQoMikNCiwgc2Vjb25kIElOVCgyKQ0KLCB1dGNfb2Zmc2V0IElO VCgyKQ0KLCB1dGNfb2Zmc2V0X2RzdCBJTlQoMikNCik7DQoNCklOU0VSVCBJTlRPIGJpel9ob3Vy cyAoeWVhcikNClNFTEVDVCAqIEZST00gZ2VuZXJhdGVfc2VyaWVzKDIwMDAsIDIwOTkpOw0KDQpJ TlNFUlQgSU5UTyBiaXpfaG91cnMgKGRveSkNClNFTEVDVCAqIEZST00gZ2VuZXJhdGVfc2VyaWVz KDEsIDM2Nik7DQoNCklOU0VSVCBJTlRPIGJpel9ob3VycyAoZG93KQ0KU0VMRUNUICogRlJPTSBn ZW5lcmF0ZV9zZXJpZXMoMSwgNyk7DQoNCklOU0VSVCBJTlRPIGJpel9ob3VycyAobW9udGgpDQpT RUxFQ1QgKiBGUk9NIGdlbmVyYXRlX3NlcmllcygxLCAxMik7DQoNCklOU0VSVCBJTlRPIGJpel9o b3VycyAoZGF5KQ0KU0VMRUNUICogRlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSwgMzEpIDsNCg0KSU5T RVJUIElOVE8gYml6X2hvdXJzIChob3VyKQ0KU0VMRUNUICogRlJPTSBnZW5lcmF0ZV9zZXJpZXMo MSwgMjQpOw0KDQpJTlNFUlQgSU5UTyBiaXpfaG91cnMgKG1pbnV0ZSkNClNFTEVDVCAqIEZST00g Z2VuZXJhdGVfc2VyaWVzKDEsIDYwKTsNCg0KSU5TRVJUIElOVE8gYml6X2hvdXJzIChzZWNvbmQN ClNFTEVDVCAqIEZST00gZ2VuZXJhdGVfc2VyaWVzKDEsIDYwKTsNCg0KSU5TRVJUIElOVE8gYml6 X2hvdXJzICh1dGNfb2Zmc2V0KQ0KU0VMRUNUICogRlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSwgMjQp Ow0KDQpJTlNFUlQgSU5UTyBiaXpfaG91cnMgKHV0Y19vZmZzZXRfZHN0KQ0KU0VMRUNUICogRlJP TSBnZW5lcmF0ZV9zZXJpZXMoMSwgMjQpOw0KDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0t DQpGcm9tOiBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+IA0KU2VudDogVHVlc2RheSwgTWF5 IDcsIDIwMjQgMjoyNyBQTQ0KVG86IGppYW4gaGUgPGppYW4udW5pdmVyc2FsaXR5QGdtYWlsLmNv bT4NCkNjOiBGcmFuY2lzY28gT2xhcnRlIDxmb2xhcnRlQHBlb3BsZWNhbGwuY29tPjsgTWljaGFl bCBCb25kYXJlbmtvIDx3b3JrLm1pY2hhZWwuMjk1NkBnbWFpbC5jb20+OyBwZ3NxbC1idWdzQGxp c3RzLnBvc3RncmVzcWwub3JnOyBkZ3Jvd2xleW1sQGdtYWlsLmNvbTsgUGV0ZXIgRWlzZW50cmF1 dCA8cGV0ZXIuZWlzZW50cmF1dEBlbnRlcnByaXNlZGIuY29tPg0KU3ViamVjdDogW0VYVEVSTkFM XSBSZTogQlVHICMxODM0ODogSW5jb25zaXN0ZW5jeSB3aXRoIEVYVFJBQ1QoW2ZpZWxkXSBmcm9t IElOVEVSVkFMKTsNCg0KamlhbiBoZSA8amlhbi51bml2ZXJzYWxpdHlAZ21haWwuY29tPiB3cml0 ZXM6DQo+IE9uIFdlZCwgRmViIDIxLCAyMDI0IGF0IDQ6NTbigK9BTSBUb20gTGFuZSA8dGdsQHNz cy5wZ2gucGEudXM+IHdyb3RlOg0KPj4+IFllYWgsIEkgc2VlIHdoYXQgeW91IG1lYW46IHRoZSBv dXRwdXQgZm9yIG5lZ2F0aXZlIG1vbnRoIGNvdW50cyBpcyANCj4+PiB2ZXJ5IGJpemFycmUsIHdo ZXJlYXMgb3RoZXIgZmllbGRzIHNlZW0gdG8gYWxsIHByb2R1Y2UgdGhlIG5lZ2F0aXZlIA0KPj4+ IG9mIHdoYXQgdGhleSdkIHByb2R1Y2UgZm9yIHRoZSBhYnNvbHV0ZSB2YWx1ZSBvZiB0aGUgaW50 ZXJ2YWwuDQo+Pj4gV2UgY291bGQgZWl0aGVyIHRyeSB0byBmaXggdGhhdCBvciBkZWNpZGUgdGhh dCByZWplY3RpbmcgInF1YXJ0ZXIiDQo+Pj4gZm9yIGludGVydmFscyBpcyB0aGUgc2FuZXIgYW5z d2VyLg0KDQo+PiBBZnRlciBmb29saW5nIHdpdGggdGhlc2UgY2FzZXMgZm9yIGEgbGl0dGxlIEkn bSBpbmNsaW5lZCB0byB0aGluayB3ZSANCj4+IHNob3VsZCBkbyBpdCBhcyBhdHRhY2hlZCAobm8g dGVzdCBvciBkb2NzIGNoYW5nZXMgeWV0KS4NCg0KPiAuLi4gSSBkb24ndCBrbm93IGhvdyB0byB3 cml0ZSB0aGUgZG9jdW1lbnRhdGlvbiBmb3IgdGhlIGBxdWFydGVyYCB3aGVuIA0KPiBpdCdzIG5l Z2F0aXZlLg0KDQpBZnRlciBwb2tpbmcgYXQgaXQgc29tZSBtb3JlLCBJIHJlYWxpemVkIHRoYXQg bXkgZHJhZnQgcGF0Y2ggd2FzIHN0aWxsIHdyb25nIGFib3V0IHRoYXQuICBXZSByZWFsbHkgaGF2 ZSB0byBsb29rIGF0IGludGVydmFsLT5tb250aCBpZiB3ZSB3YW50IHRvIGJlaGF2ZSBwbGF1c2li bHkgZm9yIG5lZ2F0aXZlIG1vbnRocy4NCg0KSGVyZSdzIGEgbW9yZSBmbGVzaGVkLW91dCBwYXRj aC4gIEkgZG9uJ3QgdGhpbmsgd2UgcmVhbGx5IG5lZWQgdG8gZG9jdW1lbnQgdGhlIGJlaGF2aW9y IGZvciBuZWdhdGl2ZSBpbnRlcnZhbHM7IGF0IGxlYXN0LCB3ZSBoYXZlbid0IGRvbmUgdGhhdCBz byBmYXIgZm9yIGFueSBvdGhlciBmaWVsZHMuICBJIGRpZCBhZGQgdGVzdGluZyBvZiBzdWNoIGNh c2VzIHRob3VnaC4NCg0KCQkJcmVnYXJkcywgdG9tIGxhbmUNCg0K