Re: [Jdbc-commits] JDBC and real values returned by Postgres

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: o(dot)bouiron(at)isc84(dot)org, h(dot)henoch(at)isc84(dot)org
Cc: PostgreSQL - JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [Jdbc-commits] JDBC and real values returned by Postgres
Date: 2010-04-28 00:04:00
Message-ID: 4BD77B70.40603@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2010-04-28 00:22:21 Re: Connection problems with jdbc
Previous Message Andrew Brunette 2010-04-27 23:38:18 Connection problems with jdbc