Here is a blog post I wrote about using a recursive query to pull out this kind of tree: http://illuminatedcomputing.com/posts/2014/09/postgres-cte-for-threade

Here is a blog post I wrote about using a recursive query to pull out this kind of tree: http://illuminatedcomputing.com/posts/2014/09/postgres-cte-for-threaded-comments/ http://illuminatedcomputing.com/posts/2014/09/postgres-cte-f... The problem I was tackling was making the tree sorted like you see in threaded, scored comments.