Re: Java : Postgres double precession issue with different data format text and binary

2024-03-18 Thread Chapman Flack
Hi Rahul, On 03/18/24 15:52, Rahul Uniyal wrote: > Since the column format is text and not binary it converts the value > to BigDecimal and give back the value as 40 . > ... > Now since the format is Binary ... it returns DOUBLE from there > result in 40.0 > > Now i am not sure for the same

Re: Java : Postgres double precession issue with different data format text and binary

2024-03-18 Thread Rahul Uniyal
Hello Chapman, Thanks for the reply and suggestion. Below are my observations when i was debugging the code of postgres-jdbc driver for double precision data type. 1- When the value in DB is 40 and fetched value is also 40 A - In the QueryExecuterImpl class method - receiveFields() , we

Re: Java : Postgres double precession issue with different data format text and binary

2024-03-18 Thread Chapman Flack
Hi, On 03/16/24 11:10, Rahul Uniyal wrote: > We are encountering an issue where the double precision data type > in PostgreSQL is giving some intermittent results when fetching data. > For example, in the database the value is 40, but sometimes this value > is fetched as 40.0. Similarly, for a

Java : Postgres double precession issue with different data format text and binary

2024-03-18 Thread Rahul Uniyal
Hello Team, Hope everyone is doing well here. I am writing this email to understand an issue I'm facing when fetching data in our Java application. We are using PostgreSQL JDBC Driver version 42.6.0. Issue: We are encountering an issue where the double precision data type in PostgreSQL is