Postgres Pro
Downloads
Home   >   mailing lists

Re: [Jdbc-commits] JDBC and real values returned by Postgres - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: [Jdbc-commits] JDBC and real values returned by Postgres
Date
Msg-id 4BD77B70.40603@opencloud.com
Whole thread Raw
Responses Re: [Jdbc-commits] JDBC and real values returned by Postgres  (Olivier Bouiron <o.bouiron@isc84.org>)
List pgsql-jdbc
Tree view 
Olivier Bouiron wrote:

> Under the psql editor, when I want the sum of these 3 rows, the answer
> is 5.4.
> But, under Java using the JDBC connector, the answer is 5.399999
>
> I tried to use an other connector (postgresql-8.2-510.jdbc4) and the
> problem disapears.

I'd guess that it is due to newer drivers setting extra_float_digits.
See http://archives.postgresql.org/pgsql-jdbc/2009-05/msg00077.php

-O

pgsql-jdbc by date:

Previous
From: Andrew Brunette
Date:
Subject: Connection problems with jdbc
Next
From: Tom Lane
Date:
Subject: Re: Connection problems with jdbc