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 1raxIz-00CKpv-M1 for pgsql-bugs@arkaria.postgresql.org; Fri, 16 Feb 2024 12:27:01 +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 1raxIy-001h5K-C3 for pgsql-bugs@arkaria.postgresql.org; Fri, 16 Feb 2024 12:27:00 +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 1rawzl-001dUI-WF for pgsql-bugs@lists.postgresql.org; Fri, 16 Feb 2024 12:07:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rawzj-007V9s-3l for pgsql-bugs@lists.postgresql.org; Fri, 16 Feb 2024 12:07:09 +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=NFB/3JAYl2FBvILuyb87J7a3GxmpH+sjNy6ZIPK/qdc=; b=AM6yCIzhv7aZ/jnlf4ziFdeoRL PI2gWBCdrQnKZHr5hBJSF6skO13BlT784eTkfC5XJjLl9+llKXELgW0a1i+IYAS3ghTXYH/4SAtqi TSf5hE3k/tBjkbFeggniIFnotbHS8rYbMg3Ars67a2b+Y2y2LPAPy0mfpl46L1BRoH0AWGXxSG9Nr lspxCn8DRq2+KRRovtMKA77vF+JUvqLNUSC7uj44irElAj6+4s+AXHh4v2T4eUE8bb/cj2o4neAPd Rg5ziiNnjH3/JoGcJo+nU55ubdtZarGOc3jrJyvUYVqLDCZ4VWr2AzM/EvJ3Q2cVsejR95zxlIlk2 tD/P7XYw==; 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 1rawzh-003Skq-BK for pgsql-bugs@lists.postgresql.org; Fri, 16 Feb 2024 12: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 1rawze-009neL-7F for pgsql-bugs@lists.postgresql.org; Fri, 16 Feb 2024 12:07:02 +0000 Content-Type: multipart/mixed; boundary="===============7474284429227317494==" MIME-Version: 1.0 Subject: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: work.michael.2956@gmail.com Reply-To: work.michael.2956@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 16 Feb 2024 12:06:55 +0000 Message-ID: <18348-b097a3587dfde8a4@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 --===============7474284429227317494== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODM0OApMb2dnZWQgYnk6ICAgICAgICAgIE1pY2hhZWwgQm9uZGFyZW5r bwpFbWFpbCBhZGRyZXNzOiAgICAgIHdvcmsubWljaGFlbC4yOTU2QGdtYWlsLmNvbQpQb3N0Z3Jl U1FMIHZlcnNpb246IDE0LjEwCk9wZXJhdGluZyBzeXN0ZW06ICAgbWFjT1MKRGVzY3JpcHRpb246 ICAgICAgICAKCkhlbGxvLA0KDQpJJ20gYnVpbGRpbmcgYSByYW5kb20gc2VtYW50aWNhbGx5LWNv cnJlY3QgU1FMIGNvZGUgZ2VuZXJhdG9yIGZvciBQb3N0Z3JlU1FMCmFuZCBJIHN0dW1ibGVkIHVw b24gYW4gaW5jb25zaXN0ZW5jeToNCg0KdHBjaD0jIHNlbGVjdCBleHRyYWN0KHllYXIgZnJvbSBp bnRlcnZhbCAnMyB5ZWFycycpOw0KIGV4dHJhY3QgDQotLS0tLS0tLS0NCiAgICAgICAzDQooMSBy b3cpDQoNCnRwY2g9IyBzZWxlY3QgZXh0cmFjdCh3ZWVrIGZyb20gaW50ZXJ2YWwgJzMgd2Vla3Mn KTsNCkVSUk9SOiAgaW50ZXJ2YWwgdW5pdHMgIndlZWsiIG5vdCBzdXBwb3J0ZWQNCg0KSW4gdGhl IGRvY3VtZW50YXRpb24gaXQncyBtZW50aW9uZWQgdGhhdCAnd2VlaycgaXMgYW4gSVNPIDg2MDEg d2Vlaywgc28gaXQKbWFrZXMgc2Vuc2Ugd2h5IGl0J3Mgbm90IGFwcGxpY2FibGUgdG8gSU5URVJW QUwsIHdoaWNoIGlzIHRoZSBzYW1lIGZvcgppc295ZWFyLiBIb3dldmVyLCB0aGUgZmllbGQgaXMg bmFtZWQgd2VlayBhbmQgbm90IGlzb3dlZWssIHNvIEkgZXhwZWN0IGl0IHRvCndvcmsgbGlrZSB0 aGUgYHNlbGVjdCBleHRyYWN0KHllYXIgZnJvbSBpbnRlcnZhbCAnMyB5ZWFycycpO2AgZG9lcy4K TW9yZW92ZXIsIHRoZSBkb2N1bWVudGF0aW9uIGRvZXMgbm90IG1lbnRpb24gdGhhdCB0aGUgZmll bGQgY2Fubm90IGJlCmV4dHJhY3RlZCBmcm9tIElOVEVSVkFMLCBsaWtlIGl0IGRvZXMgZm9yIGlz b3llYXI6Cmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvY3VycmVudC9mdW5jdGlvbnMt ZGF0ZXRpbWUuaHRtbCNGVU5DVElPTlMtREFURVRJTUUtRVhUUkFDVAouCgo= --===============7474284429227317494==--