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