Regardless of type used… the driver and server should agree on the results.
On Jan 3, 2014, at 6:06 PM, Scott Marlowe <scott.marl...@gmail.com> wrote: > On Fri, Jan 3, 2014 at 5:55 PM, Adrian Klaver <adrian.kla...@gmail.com> 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-j...@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
