Tom Lane wrote: > > SELECT DISTINCT ON place * FROM table ORDER BY place, time DESC; > > might do the right
thing. It *seems* to select the first row for each > value of place. I've never seen a spec for this feature,
however,so > I'm not sure if it's reliable or not...
Cool idea. Is DISTINCT guarranteed to choose the first row that
matches or can it choose any row?
Cheers,
Brook