On Wed, May 28, 2003 at 14:08:02 -0400,
Dave Tenny <tenny(at)attbi(dot)com> wrote:
> Andreas Pflug wrote:
>
> 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).
Have you tried replacing max with a subselect that uses order by and limit?