Postgres Pro
Downloads
Home   >   mailing lists

Common table expressions and threaded comments - Mailing list pgsql-general

From Cultural Sublimation
Subject Common table expressions and threaded comments
Date
Msg-id 19850.44178.qm@web63407.mail.re1.yahoo.com
Whole thread Raw
Responses Re: Common table expressions and threaded comments
Re: Common table expressions and threaded comments
List pgsql-general
Tree view 
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?

Thank you!
C.S.

pgsql-general by date:

Previous
From: Janning Vygen
Date:
Subject: Re: Problem with invalid byte sequence and log_min_error_statement
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Common table expressions and threaded comments