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 1qtJzB-00BwKZ-16 for pgsql-general@arkaria.postgresql.org; Thu, 19 Oct 2023 03:46:13 +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 1qtJz8-00CIzR-3Z for pgsql-general@arkaria.postgresql.org; Thu, 19 Oct 2023 03:46:10 +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 1qtJz7-00CIzI-7y for pgsql-general@lists.postgresql.org; Thu, 19 Oct 2023 03:46:10 +0000 Received: from m1391.mail.163.com ([220.181.13.91]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qtJz0-001C0Z-W1 for pgsql-general@lists.postgresql.org; Thu, 19 Oct 2023 03:46:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Date:From:Subject:Content-Type:MIME-Version: Message-ID; bh=6bn0DzTjfenbc6cvINt2Y4TJmMiXamcwg8F+lFoRX14=; b=k u8xRkj+AKPW0Oc3pSGdIZ8fAQmlGFLOC1oINZcho6l3KkDILgsaLIL7GFiQfRV42 IoGWwP8+JvqH8HudSeH5shmK2pPkP3FfEru7X2KHDVxRaj9wXRZ7jw8bQFMcVoHL rRp9ZvZE+eGZ3rIIpMsgQncp+CSBedspkZU6SkGQvU= Received: from krave$163.com ( [58.41.105.14] ) by ajax-webmail-wmsvr91 (Coremail) ; Thu, 19 Oct 2023 11:45:54 +0800 (CST) X-Originating-IP: [58.41.105.14] Date: Thu, 19 Oct 2023 11:45:54 +0800 (CST) From: =?GBK?B?w6vDqw==?= To: pgsql-general@lists.postgresql.org Subject: How can I accurately infer the output of a SELECT statement FROM a table with floating-point data type? X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.14 build 20230109(dcb5de15) Copyright (c) 2002-2023 www.mailtech.cn 163com X-NTES-SC: AL_QuySBfqTuEku4iSbbOkfm00Rgek4W8Wzv/8g3I5TPp5+jD7n+wE4e3ZKG0bw4umLBz6vlBGeQBxF7f1cfKZ5QKU5ZgKSUeEKUm+RGLLegnQo3w== Content-Type: multipart/alternative; boundary="----=_Part_38491_1176377253.1697687154441" MIME-Version: 1.0 Message-ID: <10b02a08.28b4.18b460a2f09.Coremail.krave@163.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: W8GowAD3_5hypjBlctMYAA--.3080W X-CM-SenderInfo: xnud4vi6rwjhhfrp/1tbiEAMO818YL1ZasgADs7 X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_38491_1176377253.1697687154441 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 SGksCgoKRG8gd2UgaGF2ZSBhIHJ1bGUgYnkgZm9sbG93IHdoaWNoIG9uZSBjYW4gYWNjdXJhdGVs eSBpbmZvIHRoZSBvdXRwdXQgb2YgYSBTRUxFQ1Qgc3RhdG1lbnQgRlJPTSBhIHRhYmxlIHdpdGgg ZmxvYXRpbmctcG9pbnQgZGF0YSB0eXBlPwoKCkkgYW0gd29ya2luZyB3aXRoIFBvc3RncmVTUUwg MTYgYW5kIHBnQWRtaW4gNy42LgoKCkhlcmUgaXMgbXkgU1FMIHNjcmlwdDoKCgpgYGAKCkNSRUFU RSBUQUJMRSBURVNUIChSRUFMX0NPTFVNTiByZWFsKTsKCklOU0VSVCBJTlRPIFRFU1QKVkFMVUVT ICgxMjM0NS4xMjM0NTY3ODkpOwoKU0VMRUNUICogRlJPTSBURVNUOwpgYGAKCgoKSSBjb25zdWx0 ZWQgdGhlIGZvbGxvd2luZyBkb2MgYW5kIGZvdW5kIHRoYXQgdGhlIHJhbmdlIG9mIHJlYWwgdHlw ZSBpcyA2IGRlY2ltYWwgZGlnaXRzIHByZWNpc2lvbi4KaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5v cmcvZG9jcy9jdXJyZW50L2RhdGF0eXBlLW51bWVyaWMuaHRtbCNEQVRBVFlQRS1OVU1FUklDCgoK ClNvIEkgdGhvdWdodCB0aGUgb3V0cHV0IG9mIHRoZSBTRUxFQ1Qgc3RhdGVtZW50IHNob3VsZCBi ZSBsaWtlOiAxMjM0NS4xIHdpdGggNiBkaWdpdHMgaW4gdG90YWwuCkJ1dCBpdCB0dXJucyBvdXQg dG8gYmUgMTIzNDUuMTIzIHdpdGggOCBkaWdpdHMgaW4gdG90YWwuCgpNYXkgSSBrbm93IHdoeSB3 b3VsZCB0aGlzIGhhcHBlbj8KRG8gd2UgaGF2ZSBhIHJ1bGUgSSBjYW4gdXNlIHRvIGluZmVyIHRo ZSBjb3JyZWN0IG91dHB1dCBvZiBhIGZsb2F0aW5nLXBvaW50IG51bWJlciB3aXRob3V0IHJ1bm5p bmcgdGhlIHNjcmlwdD8KCgpUaGFuayB5b3UgZm9yIHlvdXIgdGltZSBhbmQgaGF2ZSBhIGdyZWF0 IGRheSE= ------=_Part_38491_1176377253.1697687154441 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXYgc3R5bGU9Im1hcmdpbjowOyI+SGksPC9kaXY+PGRpdiBz dHlsZT0ibWFyZ2luOjA7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7Ij5Ebwogd2Ug aGF2ZSBhIHJ1bGUgYnkgZm9sbG93IHdoaWNoIG9uZSBjYW4gYWNjdXJhdGVseSBpbmZvIHRoZSBv dXRwdXQgb2YgYSAKU0VMRUNUIHN0YXRtZW50IEZST00gYSB0YWJsZSB3aXRoIGZsb2F0aW5nLXBv aW50IGRhdGEgdHlwZT88L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MDsiPjxicj48L2Rpdj48ZGl2 IHN0eWxlPSJtYXJnaW46MDsiPkkgYW0gd29ya2luZyB3aXRoIFBvc3RncmVTUUwgMTYgYW5kIHBn QWRtaW4gNy42LjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowOyI+PGJyPjwvZGl2PjxkaXYgc3R5 bGU9Im1hcmdpbjowOyI+SGVyZSBpcyBteSBTUUwgc2NyaXB0OjwvZGl2PjxkaXYgc3R5bGU9Im1h cmdpbjowOyI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowOyI+YGBgPGJyPjwvZGl2Pjxk aXYgc3R5bGU9Im1hcmdpbjowOyI+Q1JFQVRFIFRBQkxFIFRFU1QgKFJFQUxfQ09MVU1OIHJlYWwp Ozxicj48YnI+SU5TRVJUIElOVE8gVEVTVDxicj5WQUxVRVMgKDEyMzQ1LjEyMzQ1Njc4OSk7PGJy Pjxicj5TRUxFQ1QgKiBGUk9NIFRFU1Q7PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7Ij5gYGA8 YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFy Z2luOjA7Ij5JIGNvbnN1bHRlZCB0aGUgZm9sbG93aW5nIGRvYyBhbmQgZm91bmQgdGhhdCB0aGUg cmFuZ2Ugb2YgcmVhbCB0eXBlIGlzIDYgZGVjaW1hbCBkaWdpdHMgcHJlY2lzaW9uLjwvZGl2Pjxk aXYgc3R5bGU9Im1hcmdpbjowOyI+PGEgX3NyYz0iaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcv ZG9jcy9jdXJyZW50L2RhdGF0eXBlLW51bWVyaWMuaHRtbCNEQVRBVFlQRS1OVU1FUklDIiBocmVm PSJodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1cnJlbnQvZGF0YXR5cGUtbnVtZXJp Yy5odG1sI0RBVEFUWVBFLU5VTUVSSUMiPmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3Mv Y3VycmVudC9kYXRhdHlwZS1udW1lcmljLmh0bWwjREFUQVRZUEUtTlVNRVJJQzwvYT48YnI+PC9k aXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7 Ij4gU28gSSB0aG91Z2h0IHRoZSBvdXRwdXQgb2YgdGhlIFNFTEVDVCBzdGF0ZW1lbnQgc2hvdWxk IGJlIGxpa2U6IDEyMzQ1LjEgd2l0aCA2IGRpZ2l0cyBpbiB0b3RhbC48L2Rpdj48ZGl2IHN0eWxl PSJtYXJnaW46MDsiPkJ1dCBpdCB0dXJucyBvdXQgdG8gYmUgMTIzNDUuMTIzIHdpdGggOCBkaWdp dHMgaW4gdG90YWwuPGJyPjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowOyI+TWF5IEkga25vdyB3 aHkgd291bGQgdGhpcyBoYXBwZW4/PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOjA7Ij5EbyB3ZSBo YXZlIGEgcnVsZSBJIGNhbiB1c2UgdG8gaW5mZXIgdGhlIGNvcnJlY3Qgb3V0cHV0IG9mIGEgZmxv YXRpbmctcG9pbnQgbnVtYmVyIHdpdGhvdXQgcnVubmluZyB0aGUgc2NyaXB0PzwvZGl2PjxkaXYg c3R5bGU9Im1hcmdpbjowOyI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowOyI+VGhhbmsg eW91IGZvciB5b3VyIHRpbWUgYW5kIGhhdmUgYSBncmVhdCBkYXkhPC9kaXY+PHAgc3R5bGU9Im1h cmdpbjowOyI+PC9wPjwvZGl2Pg== ------=_Part_38491_1176377253.1697687154441--