Index: openacs-4/packages/acs-subsite/www/admin/group-types/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/group-types/index-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-subsite/www/admin/group-types/index-postgresql.xql	28 Nov 2001 18:39:39 -0000	1.2
+++ openacs-4/packages/acs-subsite/www/admin/group-types/index-postgresql.xql	4 Dec 2001 00:20:47 -0000	1.3
@@ -14,7 +14,7 @@
 	      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
                    left outer join
            (select o.object_type, count(*) as number_groups
               from groups g, acs_objects o,