Re: using max() aggregate

On Fri, Jun 16, 2000 at 02:05:53AM -0400, Tom Lane wrote:
> Louis-David Mitterrand <cunctator@apartia.ch> writes:
> > I am trying to return the most recently updated record from a table:
> > SELECT max(stopdate) FROM auction;
> > and this works but only returns the timestamp, however if I try to get
> > another column with the aggregate it fails:
>
> Perhaps
>
> select * from auction order by stopdate desc limit 1;
>
> In 7.0 this should even be pretty quick, if you have an index on
> stopdate.

Thanks, yours seems to be the best solution.

The performance hit between max() and ORDER BY should be roughly
comparable?

--
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.fr