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