Index: openacs-4/packages/acs-subsite/www/admin/group-types/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/group-types/one-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/group-types/one-postgresql.xql	15 May 2001 16:59:00 -0000	1.1
+++ openacs-4/packages/acs-subsite/www/admin/group-types/one-postgresql.xql	4 Dec 2001 00:20:47 -0000	1.2
@@ -35,7 +35,7 @@
 		   tree_level(t2.tree_sortkey) - tree_level(t1.tree_sortkey) + 1 as type_level		   	
               from acs_object_types t1, acs_object_types t2
 	     where t1.object_type = 'group'
-	       and t2.tree_sortkey like t1.tree_sortkey || '%') t
+	       and t2.tree_sortkey between t1.tree_sortkey and tree_right(t1.tree_sortkey)) t
      where a.object_type = :group_type
        and t.object_type = a.ancestor_type
     order by type_level