--- 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

Reply via email to