Regardless of type used… the driver and server should agree on the results. On Jan 3, 2014, at 6:06 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Fri, Jan 3, 2014 at 5:55 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > >> Only thing I can think of is the JDBC driver and Postgres have a difference >> of opinion on the precision of double precision. What happens if you >> eliminate the double precision cast? > > This brings up the point as well, don't use floating point numbers if > you want precise answers. > > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general