--- On Wed, 12/12/07, Uwe C. Schroeder <[EMAIL PROTECTED]> wrote:
> The comments table also has a field that holds a
> self-reference to comment id
> for commments on comments (on comments) of a blog.
The model that you are referring to here is the adjacency list hierarchy
model. There are two other models that will give you what you want but are
harder to implement: path enumeration model and the nested set model. My guess
is that the path enumeration model with give you what to want with a decent
insert performance. Aside from this there is the ltree contribe module that
take care of a lot of the work for you.
> What I would like to do is to create a view that sucks the
> comments for a
> given blog_id in the order they should be displayed (very
> commonly seen in
> pretty much all blogging apps), i.e.
Yup that is the problem with the adjacency list model.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
