Louis-David Mitterrand <cunctator(at)apartia(dot)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