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@gmail.com> wrote:
> On Fri, Jan 3, 2014 at 5:55 PM, Adrian Klaver <adrian.klaver@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-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc