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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christian van der Leeden <lists(at)logicunited(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: range query with timestamp returns different result with index than without (7.3.3)
Date: 2003-08-07 14:06:35
Message-ID: 15029.1060265195@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Christian van der Leeden <lists(at)logicunited(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-08-07 14:23:16 Re: Follow up: range query with timestamp returns different result with index than without (7.3.3)
Previous Message Troels Arvin 2003-08-07 11:04:37 Non-standard TIMESTAMP WITH TIME ZONE literal handling