On Tue, Jul 29, 2003 at 09:48:37 -0600,
  "Valsecchi, Patrick" <[EMAIL PROTECTED]> 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;

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to