Index: openacs-4/packages/acs-subsite/www/admin/groups/new-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/groups/new-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-subsite/www/admin/groups/new-postgresql.xql 15 May 2001 16:59:00 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/admin/groups/new-postgresql.xql 4 Dec 2001 00:20:47 -0000 1.2 @@ -13,8 +13,7 @@ select t2.object_type from acs_object_types t1, acs_object_types t2 where t1.object_type = :add_with_rel_type - and t2.tree_sortkey <= t1.tree_sortkey - and t1.tree_sortkey like (t2.tree_sortkey || '%') + and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey) )