Re: using max() aggregate - Mailing list pgsql-general

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.

            regards, tom lane