Index: openacs-4/contrib/obsolete-packages/bboard/www/message-threaded-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/www/message-threaded-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/bboard/www/message-threaded-postgresql.xql	29 Jun 2001 20:37:18 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/bboard/www/message-threaded-postgresql.xql	1 Dec 2001 22:25:58 -0000	1.2
@@ -27,14 +27,12 @@
          tree_level(m.tree_sortkey) - 1 as thread_depth, 
       acs_permission__permission_p(m.message_id, :user_id,
                                   'bboard_write_message') as write_p
-    from acs_messages_all m, persons p
-   where m.tree_sortkey like (select tree_sortkey
-                                from acs_messages am
-                               where am.message_id = :message_id) || '/%'
+    from acs_messages_all m, persons p, acs_messages m2, bboard_forum_message_map bfmm
+   where m2.message_id = :message_id
+     and bfmm.forum_id = :forum_id
+     and m.tree_sortkey between m2.tree_sortkey and tree_right(m2.tree_sortkey)
      and p.person_id = m.sender
-     and m.message_id in (select bfmm.message_id 
-                            from bboard_forum_message_map bfmm
-                           where bfmm.forum_id = :forum_id)
+     and m.message_id = bfmm.message_id 
    order by m.sent_date
 
       </querytext>