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 1vFkcs-000BAY-B8 for pgsql-bugs@arkaria.postgresql.org; Mon, 03 Nov 2025 02:48:57 +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 1vFkcq-00GOdJ-5q for pgsql-bugs@arkaria.postgresql.org; Mon, 03 Nov 2025 02:48:55 +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 1vFkcp-00GOVy-Sm for pgsql-bugs@lists.postgresql.org; Mon, 03 Nov 2025 02:48:54 +0000 Received: from m16.mail.126.com ([117.135.210.6]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vFkci-0058vA-0p for pgsql-bugs@lists.postgresql.org; Mon, 03 Nov 2025 02:48:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:To:Subject:Content-Type:MIME-Version: Message-ID; bh=H0d/h1acQa4iicJ1ySx3ixflXAfpqRvj5ai0kAwFKmU=; b=H 4shobVjQTEXppR6zyU9RmVq4X2PeHSImdBOV+DKIdwFTza5+ZV067l2f6N8siGte Lt6r5wHIYEUh7Ev9qAxJGmyMRSJR24QIWqpkb3K4te5qRebh/yuDGwUH1BCFUKM+ 1SoZA8anH9Y6C87ImyKZJ1MiZHpFwkO0OCO34ytcwQ= Received: from dqetool$126.com ( [2401:b180:8001:800c:eb2d:aca4:eb2d:aca4] ) by ajax-webmail-wmsvr-41-107 (Coremail) ; Mon, 3 Nov 2025 10:48:34 +0800 (CST) X-Originating-IP: [2401:b180:8001:800c:eb2d:aca4:eb2d:aca4] Date: Mon, 3 Nov 2025 10:48:34 +0800 (CST) From: dqetool To: "Tom Lane" Cc: pgsql-bugs@lists.postgresql.org Subject: Re:Re: BUG #19101: Ceil on BIGINT could lost precision in decil function X-Priority: 3 X-Mailer: Coremail Webmail Server Version 2023.4-cmXT build 20250723(a044bf12) Copyright (c) 2002-2025 www.mailtech.cn 126com In-Reply-To: <427381.1762101326@sss.pgh.pa.us> References: <19101-8f44b0e27aa65d40@postgresql.org> <427381.1762101326@sss.pgh.pa.us> Content-Transfer-Encoding: base64 Content-Type: text/plain; charset=us-ascii MIME-Version: 1.0 Message-ID: <43e5b082.29f0.19a479dcb70.Coremail.dqetool@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: aykvCgDXnxADGAhpqk8WAA--.49041W X-CM-SenderInfo: xgth30lro6ij2wof0z/1tbiWQL6O2kIEiGjNAABse X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhhbmtzIGZvciB0aGUgcXVpY2sgcmVzcG9uc2UuIEkgdHJ5IHRvIGFkZCBhbiBleHBsaWNpdCB0 eXBlIGNvbnZlcnNpb24gdG8gYXZvaWQgdGhpcyBwcm9ibGVtLgpBdCAyMDI1LTExLTAzIDAwOjM1 OjI2LCAiVG9tIExhbmUiIDx0Z2xAc3NzLnBnaC5wYS51cz4gd3JvdGU6Cj5QRyBCdWcgcmVwb3J0 aW5nIGZvcm0gPG5vcmVwbHlAcG9zdGdyZXNxbC5vcmc+IHdyaXRlczoNCj4+IEkgdHJ5IHRvIHN0 b3JlIGEgbGFyZ2UgbnVtYmVyIGluIGBCSUdJTlRgIGFuZCBydW4gIGBjZWlsKGMxKWAgY29tbWFu ZC4NCj4+IEhvd2V2ZXIsIHRoZSByZXN1bHQgbG9zdCBzb21lIHByZWNpc2lvbiBkdWUgdG8gY2Fs bGluZyBgZGVjaWxgIGZ1bmN0aW9uLg0KPj4gYGBgc3FsDQo+PiBDUkVBVEUgVEFCTEUgdDEgKGMx IEJJR0lOVCk7DQo+PiBJTlNFUlQgSU5UTyB0MSBWQUxVRVMgKDQ4NTQyMzMwMzQ0NDA5Nzk3OTkp Ow0KPj4gLS0gZGNlaWwNCj4+IFNFTEVDVCBjZWlsKGMxKSBGUk9NIHQxOyAtLSB7NC44NTQyMzMw MzQ0NDA5NzllKzE4fQ0KPj4gYGBgDQo+DQo+VGhpcyBpcyBub3QgYSBidWcuICBUaGVyZSBhcmUg dHdvIHZlcnNpb25zIG9mIGNlaWwoKSBhbmQgeW91J3JlDQo+aW52b2tpbmcgdGhlIHdyb25nIG9u ZS4gIFlvdSdkIG5lZWQgdG8gZXhwbGljaXRseSBjYXN0IHRoZQ0KPmFyZ3VtZW50IHRvIG51bWVy aWMgaWYgeW91IHdhbnQgY2VpbChudW1lcmljKSB0byBiZSB1c2VkLg0KPg0KPkluIHRoaXMgY29u dGV4dCBpdCdzIGEgYml0IHVuZm9ydHVuYXRlIHRoYXQgdGhlIHBhcnNlcidzIHR5cGUNCj5wcmVm ZXJlbmNlIHJ1bGVzIFsxXSBwcmVmZXIgZmxvYXQ4IHRvIG51bWVyaWMuICBCdXQgd2UncmUgcHJl dHR5DQo+bXVjaCBzdHVjayB3aXRoIHRoYXQgYmVoYXZpb3IgYmVjYXVzZSAoYSkgdGhlIFNRTCBz dGFuZGFyZA0KPnNheXMgc28gWzJdLCBhbmQgKGIpIGV2ZW4gaWYgaXQgZGlkbid0LCB3ZSBoYXZl IGEgY291cGxlIG9mDQo+ZGVjYWRlcyBvZiBoaXN0b3J5IHRvIGJlIGJhY2t3YXJkcyBjb21wYXRp YmxlIHdpdGguDQo+DQo+CQkJcmVnYXJkcywgdG9tIGxhbmUNCj4NCj5bMV0gaHR0cHM6Ly93d3cu cG9zdGdyZXNxbC5vcmcvZG9jcy9jdXJyZW50L3R5cGVjb252Lmh0bWwNCj4NCj5bMl0gV2VsbCwg d2hhdCBpdCByZWFsbHkgc2F5cyBpcyB0aGF0IGV4cHJlc3Npb25zIHRoYXQgbWl4DQo+ZXhhY3Qg YW5kIGluZXhhY3QgbnVtZXJpYyB0eXBlcyBwcm9kdWNlIGluZXhhY3QgcmVzdWx0cy4NCj5XZSBp bnRlcnByZXQgdGhhdCBhcyBtZWFuaW5nIHRoYXQgZmxvYXQ4IGlzIHRoZSBwcmVmZXJyZWQNCj50 eXBlIGluIHRoZSBudW1lcmljIGNhdGVnb3J5LCBzbyBpdCB3aW5zIGFtYmlndW91cyBjYXNlcy4N Cg==