Re: [GENERAL] Creating an index alters the results returned

From: Kevin Wooten <kdubb(at)me(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, Clemens Eisserer <linuxhippy(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [GENERAL] Creating an index alters the results returned
Date: 2014-01-04 01:07:30
Message-ID: 165094DE-AA45-45BD-B16D-722047FD6AA8@me.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Regardless of type used… the driver and server should agree on the results.

On Jan 3, 2014, at 6:06 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-01-04 01:37:44 Re: Suddenly all tables were gone
Previous Message Scott Marlowe 2014-01-04 01:06:43 Re: Creating an index alters the results returned

Browse pgsql-jdbc by date

  From Date Subject
Next Message Pawel Veselov 2014-01-13 23:26:46 How can this abstract method error happen?
Previous Message Scott Marlowe 2014-01-04 01:06:43 Re: Creating an index alters the results returned