Common table expressions and threaded comments

From: Cultural Sublimation <cultural_sublimation(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Common table expressions and threaded comments
Date: 2009-04-17 12:40:22
Message-ID: 19850.44178.qm@web63407.mail.re1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-04-17 12:53:35 Re: Common table expressions and threaded comments
Previous Message Janning Vygen 2009-04-17 12:01:45 Re: Problem with invalid byte sequence and log_min_error_statement