> I'm reminded to relay to the PostgreSQL devos that I might be able to do
> more in the join or subquery department if
> PostgreSQL had better performing MAX functions and a FIRST function for
> selecting rows from groups.
> ("Performing" being the operative word here, since the extensible
> architecture of PostgreSQL currently makes for poorly
> performing MAX capabilities and presumably similar user defined
> aggregate functions).
MIN/MAX is almost in every case replaceable:
select bar
from foo
order by bar limit 1;
instead of
select max(bar) from foo;