Request a Demo
Home   >   mailing lists

Re: Sorting with DISTINCT ON - Mailing list pgsql-general

From Nico Grubert
Subject Re: Sorting with DISTINCT ON
Date
Msg-id 45A25B2A.9060203@gmail.com
Whole thread Raw
In response to Re: Sorting with DISTINCT ON  (Jorge Godoy <jgodoy@gmail.com>)
List pgsql-general
Tree view 
> 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

Thank you very much. Works perfect! :-)

pgsql-general by date:

Previous
From: Walter Vaughan
Date:
Subject: Re: Advice needed on using postgres in commercial product
Next
From: "Shoaib Mir"
Date:
Subject: Re: Command "connect by prior" in PostgreSQL ?