Nico Grubert <nicogrubert@gmail.com> writes:
> My first try was this SQL query:
>
> SELECT DISTINCT ON (path) path, comment_id, created, title
> FROM bewertungen.tblcomments
>
> This does not allow me to append "ORDER BY created" since I can only sort on
> path because of DISTINCT ON (path).
It does allow you to sort on both columns.
SELECT DISTINCT ON (path) path, comment_id, created, title
FROM bewertungen.tblcomments ORDER BY path, created
Maybe you need a more complex query to get what you want (and use
max(created)...).
--
Jorge Godoy <jgodoy@gmail.com>