Thanks for responding, I am thinking it might be fairly beneficial to
upgrade.
> Ummm, max() is an aggregate function, how can you create an index on
> it?
In the postgresSQL Essential Reference by Barry Stinson it specifically
has a index topic on functional indexes, with the given example being
" CREATE INDEX max_payroll_idx ON payroll (MAX(salary)); "
so either the book was a waste of money, or this is a 7.2 specific
feature.
--
Chris Field
Affinity Solutions Inc.