Sorting with DISTINCT ON

Hi there,

I have a problem sorting a SQL result if I use DISTINCT ON.

I have a table "tblcomment" with these columns:
   id (serial)
   path (varchar)
   created (timestamp)
   title (varchar)

These records are in the table "tblcomment":

id  path        created                     title
------------------------------------------------------------
11  /var/black  2007-01-07 22:17:03.001837  Any title
17  /var/blue   2007-01-07 20:35:55.289713  Any title
13  /var/blue   2007-01-15 15:52:58.438375  Any title
12  /var/green  2007-01-08 19:03:50.470073  Any title
18  /var/red    2007-01-07 08:41:47.152676  Any title

Now, I want to get all results from this table and if there are
duplicates, I want the row whose "created" column has the latest date.
In this example, I want to have this result:

id  path        created                     title
------------------------------------------------------------
11  /var/black  2007-01-07 22:17:03.001837  Any title
13  /var/blue   2007-01-15 15:52:58.438375  Any title
12  /var/green  2007-01-08 19:03:50.470073  Any title
18  /var/red    2007-01-07 08:41:47.152676  Any title


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).

My second try was a sub query like this:

SELECT comment_id, path, created, title
  FROM
   ( SELECT DISTINCT ON (path) path, comment_id, created, title
     FROM bewertungen.tblcomments
   ) foo_alias
ORDER BY created DESC

But this results into:

id  path        created                     title
------------------------------------------------------------
11  /var/black  2007-01-07 22:17:03.001837  Any title
17  /var/blue   2007-01-07 20:35:55.289713  Any title
12  /var/green  2007-01-08 19:03:50.470073  Any title
18  /var/red    2007-01-07 08:41:47.152676  Any title

No matter, if I user  ORDER BY created DESC or
ORDER BY created ASC. It seems that postgres always takes the first row
of the duplicates. In this example:
   17  /var/blue   2007-01-07 20:35:55.289713  Any title.


Any idea, how I can solve my problem?


Regards,
    Nico