Christian van der Leeden <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]