Re: Index not being used in MAX function (7.2.3)

On Thu, Jun 12, 2003 at 17:26:11 -0500,
  "Jim C. Nasby" <jim@nasby.net> wrote:
> On Thu, Jun 12, 2003 at 12:08:15PM +0800, Ang Chin Han wrote:
>
> This becomes really important whenever pgsql gains the ability to use
> multiple indexes per table (someone smack me if it can do this now and I

SMACK!

> don't realize it), because then you could do something like
>
> SELECT min(a), max(b), min(c), min(d)
>
> and the query would be blazing fast if you had the right indexes on all
> 4 fields.

And you can speed this up now using subselects.