Cool thanks then not something I'm doing wrong :). Is this going to be
changed or is changed in a latter version of postgres. (Do I need to do
and upgrade or write a work around :) )
Tom Lane wrote:
> Tim Haak <timh@lucidview.net> writes:
>
>> I am running the following query again a partitioned table in 8.2.7. It
>> does index scans which is unexpected as there are indexes for the
>> log_date column.
>>
>
> The index min/max optimization only works on single tables at the
> moment. Sorry.
>
> regards, tom lane
>
>
--
Tim Haak
Email: timh@lucidview.net
Tel: +27 12 658 9019