Re: range query with timestamp returns different result with index than without (7.3.3)

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