Index: openacs-4/contrib/obsolete-packages/bboard/www/message-delete-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/www/message-delete-2-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/obsolete-packages/bboard/www/message-delete-2-postgresql.xql	2 Jul 2001 13:09:24 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/bboard/www/message-delete-2-postgresql.xql	1 Dec 2001 22:25:58 -0000	1.3
@@ -6,14 +6,9 @@
 <fullquery name="bboard_delete_threads">      
       <querytext>
 
-	delete from bboard_forum_message_map
-         where message_id in 
-               (select message_id
-                  from acs_messages m
-                 where m.tree_sortkey like 
-                       (select tree_sortkey
-                          from acs_messages am
-                         where am.message_id = :message_id) || '%')
+	delete from bboard_forum_message_map map, acs_messages m, acs_messages m2
+         where map.message_id = m.message_id
+           and m.tree_sortkey between m2.tree_sortkey and tree_right(m2.tree_sortkey) 
 
       </querytext>
 </fullquery>