Tom Lane <t...@sss.pgh.pa.us> writes: > I have a feeling that it could also be done via the "window functions" > feature due to be introduced in 8.4, but I'm not entirely sure how. > Anybody feeling handy with those?
There may be a better way but something like select * from (select *, rank() over (partition by charge order by coldspot_time desc) as r) where r = 1 ? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
