On Fri, Apr 17, 2009 at 1:40 PM, Cultural Sublimation <cultural_sublimation@xxxxxxxxx> wrote: > > Greetings, > > I need to implement the classical problem of threaded comments in a Postgresql > database. I know that the upcoming 8.4 release includes Common Table > Expressions, so I have to ask: is this feature the mother-of-all-solutions > to the threaded comments problem, or is it still worth investigating ltree? > > Also, lots of people mention Joe Celko's book on this subject. Is it still > a valid resource, or do CTE's make it obsolete? Depending on what you actually need, but yes - CTE is the solution, depending obviously on your schema design... I think David (Fetter) had some examples in his slides on how to solve common problems like that in a query. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
