Index: openacs-4/contrib/obsolete-packages/bboard/www/message-move-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/www/message-move-2-postgresql.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/bboard/www/message-move-2-postgresql.xql	29 Jun 2001 20:37:18 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/bboard/www/message-move-2-postgresql.xql	1 Dec 2001 22:25:58 -0000	1.2
@@ -5,19 +5,16 @@
 
 <fullquery name="update_bboard_contexts">      
       <querytext>
-      FIX ME CONNECT BY
 
 	update acs_objects
 	    set context_id = :dest_forum_id
 	    where context_id = :forum_id
               and object_type = 'acs_message'
               and object_id in 
                   (select message_id
-                     from acs_messages m
-                    where tree_sortkey like 
-                          (select tree_sortkey || '%'
-                             from acs_messages m
-                            where message_id = :message_id))
+                     from acs_messages m, acs_messages m2
+                    where m2.message_id = :message_id
+                      and m.tree_sortkey between m2.tree_sortkey and tree_right(m2.tree_sortkey)) 
     
       </querytext>
 </fullquery>
@@ -31,11 +28,9 @@
             where forum_id = :forum_id
               and message_id in 
                   (select message_id
-                     from acs_messages m
-                    where tree_sortkey like 
-                          (select tree_sortkey || '%'
-                             from acs_messages m
-                            where message_id = :message_id))
+                   from acs_messages m, acs_messages m2
+                   where message_id = :message_id
+                     and m.tree_sortkey between m2.tree_sortkey and tree_right(m2.tree_sortkey))
     
       </querytext>
 </fullquery>