Postgres Pro
Downloads
Home   >   mailing lists

Re: range query with timestamp returns different result with index than without (7.3.3) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: range query with timestamp returns different result with index than without (7.3.3)
Date
Msg-id 15029.1060265195@sss.pgh.pa.us
Whole thread Raw
In response to range query with timestamp returns different result with index than without (7.3.3)  (Christian van der Leeden <lists@logicunited.com>)
List pgsql-bugs
Tree view 
Christian van der Leeden <lists@logicunited.com> writes:
> without any index the range query returns the correct result namely
> 272394, when i create an index on creation_date,
> I get 10371 as a result.

This is a tad hard to believe :-(.

Could we see the full schema for the table?  ("pg_dump -s -t delivery"
would be best.)

            regards, tom lane

pgsql-bugs by date:

Previous
From: Christian van der Leeden
Date:
Subject: Follow up: range query with timestamp returns different result with index than without (7.3.3)
Next
From: Tom Lane
Date:
Subject: Re: Follow up: range query with timestamp returns different result with index than without (7.3.3)