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

2014-01-03 Thread Scott Marlowe
On Fri, Jan 3, 2014 at 5:55 PM, Adrian Klaver 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 po

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

2014-01-03 Thread Adrian Klaver
On 01/03/2014 11:59 AM, Clemens Eisserer wrote: Hi, Running postgres 9.1.11 + postgresql-9.3-1100.jdbc41.jar, I experience a strange phenomenon using indexes. I have the following schema: CREATE TABLE wplog (id serial NOT NULL,ts timestamp without time zone, sensor1 real, sensor2 real, noiselev

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

2014-01-03 Thread Igor Neyman
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Clemens Eisserer > Sent: Friday, January 03, 2014 3:00 PM > To: pgsql-general@postgresql.org; pgsql-j...@postgresql.org > Subject: [GENERAL] Creating an index alters t