Index: openacs-4/packages/cms/www/modules/items/revision-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/items/revision-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/cms/www/modules/items/revision-postgresql.xql 12 Jun 2001 04:13:46 -0000 1.3 +++ openacs-4/packages/cms/www/modules/items/revision-postgresql.xql 8 Dec 2001 01:18:00 -0000 1.4 @@ -87,7 +87,7 @@ and ot2.tree_sortkey <= ot1.tree_sortkey and - ot1.tree_sortkey like (ot2.tree_sortkey || '%')) o + ot1.tree_sortkey between ot2.tree_sortkey and tree_right(ot2.tree_sortkey)) o where o.object_type = attr.object_type order by