using max() aggregate - Mailing list pgsql-general

Hello,

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:

SELECT title,max(stopdate) FROM auction;
ERROR:  Attribute auction.title must be GROUPed or used in an aggregate function

Ok, so I group it now:

SELECT title,max(stopdate) FROM auction GROUP BY title;
     title     |          max
---------------+------------------------
 dfsdfsdf      | 2000-07-10 05:00:00+02
 dssdfsdfsdfsf | 2000-07-09 16:00:00+02
 sdfsdfsdfsdf  | 2001-04-10 15:00:00+02
(3 rows)

But the problem is that I now get three rows when I only want the max()
item.

How should I do it?

Thanks in advance,

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

"Logiciels libres : nourris au code source sans farine animale."