Markus Schaber <[EMAIL PROTECTED]> writes: > But as it fetches all the rows through the index, why doesn't it > recognize that, fetching this way, the rows are already sorted by > l_postcode?
Tell it to "ORDER BY cd, l_postcode".
> Is Postgresql 8 more intelligend in this case?
No.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
