Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kk0tl-0002N6-DV for pgsql-bugs@arkaria.postgresql.org; Tue, 01 Dec 2020 08:20:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kk0tk-0004fM-Bo for pgsql-bugs@arkaria.postgresql.org; Tue, 01 Dec 2020 08:20:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjzlj-0001lM-5O for pgsql-bugs@lists.postgresql.org; Tue, 01 Dec 2020 07:08:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjzle-0003fY-KQ for pgsql-bugs@lists.postgresql.org; Tue, 01 Dec 2020 07:08:10 +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=UZJZTQ8x81ymqfQPae9DPaJLpEC/wywOFRVDw9SqZR0=; b=nJWKqjYkjbq8gF4yTRpL4Xvq9o I+YwmzvWCTo7DYCmyCLbrmH9kzRH9cj9HfTbn1xF1GEgeDZQ/uU7a3/fpsbP3iDL4cufiy7JWTFrz 9LhSSOpF6gIY7lqDXOsl3ME10JDNAPG1mNofBmJ7A5zhYDDO7zM8P3jbL95tn6cCNF9eI8nWDFs7I 0/8A7abgVZ4tu84GU4bDp2JOCKI84roIWjOKufm2ST63BPNHM99miY9ZmyTNGuu/EnLzafcfIXX+/ 5aufj28hNfvw7MBTIuXUY/+aXIghCu61hzDMFHbnPDSGpoQd9XSfk4ixwtgwp/k83eDFIuKKKzKLP UJjtKnAw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjzlc-000636-S9 for pgsql-bugs@lists.postgresql.org; Tue, 01 Dec 2020 07:08:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kjzla-0005Kj-B6 for pgsql-bugs@lists.postgresql.org; Tue, 01 Dec 2020 07:08:02 +0000 Content-Type: multipart/mixed; boundary="===============3829201522978867261==" MIME-Version: 1.0 Subject: BUG #16755: A specification or a bug? Digit drop on CAST from DOUBLE PRECISION to NUMERIC. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: hisanori.kobayashi.bp@nttdata.com Reply-To: hisanori.kobayashi.bp@nttdata.com, pgsql-bugs@lists.postgresql.org Date: Tue, 01 Dec 2020 07:07:29 +0000 Message-ID: <16755-9889c3ce84f837e3@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3829201522978867261== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjc1NQpMb2dnZWQgYnk6ICAgICAgICAgIEtvYmF5YXNoaSBIaXNhbm9y aQpFbWFpbCBhZGRyZXNzOiAgICAgIGhpc2Fub3JpLmtvYmF5YXNoaS5icEBudHRkYXRhLmNvbQpQ b3N0Z3JlU1FMIHZlcnNpb246IDEyLjQKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDEwCkRl c2NyaXB0aW9uOiAgICAgICAgCgpJcyB0aGlzIGEgc3BlY2lmaWNhdGlvbj8gT3IgaXMgaXQgYSBi dWc/DQpJbiBQb3N0Z3JlU1FMIDEyLjQgZm9yIFdpbmRvd3MuDQoNCkl0IHdvdWxkIGJlIHVuZGVy c3RhbmRhYmxlIGlmIHRoZSBDQVNUIGZyb20gTlVNRVJJQyB0byBET1VCTEUgUFJFQ0lTSU9OCndv dWxkIGRpZ2l0IGRyb3AsIGJ1dCBJIGRvbid0IGtub3cgaWYgaXQncyBhIHNwZWNpZmljYXRpb24g b3IgYSBidWcgdG8gZGlnaXQKZHJvcCBvbiBDQVNUIGZyb20gRE9VQkxFIFBSRUNJU0lPTiB0byBO VU1FUklDLiAodHJhbnNsYXRlZCBieSBEZWVwTCkNCg0KLS0tLS0gDQpwb3N0Z3Jlcz0+IHNlbGVj dCAoMTIzNDU2Nzg5MDEyMzQ1Ojpkb3VibGUgcHJlY2lzaW9uICogMTEpIDsNCiAgICAgP2NvbHVt bj8NCi0tLS0tLS0tLS0tLS0tLS0tLQ0KIDEuMzU4MDI0Njc5MTM1Nzk1ZSsxNSAgICAgICAgICAg ICAgICAgPC0tICoqKiBObyBQcm9ibGVtKE5vIGRpZ2l0IGRyb3ApDQoNCnBvc3RncmVzPT4gc2Vs ZWN0ICgxMjM0NTY3ODkwMTIzNDU6OmRvdWJsZSBwcmVjaXNpb24gKiAxMSk6Om51bWVyaWMgOw0K ICAgICBudW1lcmljDQotLS0tLS0tLS0tLS0tLS0tLS0NCiAxMzU4MDI0Njc5MTM1ODAwICAgICAg ICAgICAgICAgICAgICAgIDwtLSAqKiogRGlnaXQgZHJvcA0KLS0tLS0KCg== --===============3829201522978867261==--