Re: Indexes not used for "min()"

On Tue, Jul 29, 2003 at 09:48:37 -0600,
"Valsecchi, Patrick" <patrick(dot)valsecchi(at)nagrastar(dot)com> wrote:
>
> When doing the following query, it's obvious that postgres should use
> the index:
>
> stats=# explain select min(time) from call;

This has been discussed on the mailing lists numerous times. If you are
interested in details you can search the archives. If you just want a faster
equivalent query use:
select time from call order by time limit 1;