On Thu, Jun 12, 2003 at 17:26:11 -0500,
"Jim C. Nasby" <jim(at)nasby(dot)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.