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 -r1.2 -r1.3 --- openacs-4/contrib/obsolete-packages/bboard/www/message-move-2-postgresql.xql 1 Dec 2001 22:25:58 -0000 1.2 +++ openacs-4/contrib/obsolete-packages/bboard/www/message-move-2-postgresql.xql 8 Dec 2001 01:17:59 -0000 1.3 @@ -11,7 +11,7 @@ where context_id = :forum_id and object_type = 'acs_message' and object_id in - (select message_id + (select m.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)) @@ -27,9 +27,9 @@ set forum_id = :dest_forum_id where forum_id = :forum_id and message_id in - (select message_id + (select m.message_id from acs_messages m, acs_messages m2 - where message_id = :message_id + where m2.message_id = :message_id and m.tree_sortkey between m2.tree_sortkey and tree_right(m2.tree_sortkey))