Postgres Pro
Downloads
Home   >   mailing lists

Sv: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue - Mailing list pgsql-jdbc

From Andreas Joseph Krogh
Subject Sv: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue
Date
Msg-id VisenaEmail.9.b226ab802321bcdc.17544a6d3e3@tc7-visena
Whole thread Raw
In response to PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue  ("Thangavel, Parameswaran" <Parameswaran.Thangavel@rsa.com>)
Responses RE: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue
List pgsql-jdbc
Tree view
På tirsdag 20. oktober 2020 kl. 05:21:51, skrev Thangavel, Parameswaran <Parameswaran.Thangavel@rsa.com>:

Hi Team,

 

I am using postgresql version 9.4.1. We are in the process of upgrading to PostgreSQL 10.

 

While doing so, we have upgraded the JDBC postgres driver from 9.1-901.jdbc4 to 42.2.5 Post the upgrade we are facing the issue with data integrity where the numeric value is getting rounded off.

 

Scenario:

I am trying to insert a value (float datatype in Java) and in DB it is represented as Numeric.

 

When I try to store, "1234567" the value is stored as "1234570".

No, it is stored as $4 = '1.234567e+06'
Which is correct as it is a 7-digit figure 1.234567 * 10^6.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-jdbc by date:

Previous
From: "Thangavel, Parameswaran"
Date:
Subject: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue
Next
From: "Thangavel, Parameswaran"
Date:
Subject: RE: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue