Index: openacs-4/contrib/obsolete-packages/bboard/tcl/bboard-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/tcl/bboard-procs-postgresql.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/contrib/obsolete-packages/bboard/tcl/bboard-procs-postgresql.xql	8 Dec 2001 01:17:59 -0000	1.9
+++ openacs-4/contrib/obsolete-packages/bboard/tcl/bboard-procs-postgresql.xql	9 Dec 2001 04:21:58 -0000	1.10
@@ -411,10 +411,10 @@
   <querytext>
         select s.subscriber_id as recipient_id, s.thread_id as grouping_id,
                now() as wait_until
-          from bboard_thread_subscribers s, acs_messages m, acs_messages m2
+          from bboard_thread_subscribers s, acs_messages m,
+            (select tree_ancestor_keys(acs_message_get_tree_sortkey(:message_id)) as tree_sortkey) parents
          where s.thread_id = m.message_id
-           and m2.message_id = :message_id
-           and m.tree_sortkey between tree_root_key(m2.tree_sortkey) and tree_right(tree_root_key(m2.tree_sortkey))
+           and m.tree_sortkey = parents.tree_sortkey
            and exists (select 1
                        from all_object_party_privilege_map map
                        where map.object_id = :message_id and