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