Re: Creating an index alters the results returned

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: Clemens Eisserer <linuxhippy(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Creating an index alters the results returned
Date: 2014-01-04 01:06:43
Message-ID: CAOR=d=1C1kdS4QnHSfCGx_TUJ-tGnuG1WrrABXROhzdgiFq0KA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Wooten 2014-01-04 01:07:30 Re: [GENERAL] Creating an index alters the results returned
Previous Message Adrian Klaver 2014-01-04 00:55:03 Re: Creating an index alters the results returned

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kevin Wooten 2014-01-04 01:07:30 Re: [GENERAL] Creating an index alters the results returned
Previous Message Adrian Klaver 2014-01-04 00:55:03 Re: Creating an index alters the results returned