Index: openacs-4/packages/acs-subsite/www/admin/rel-types/new-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/rel-types/new-2-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-subsite/www/admin/rel-types/new-2-postgresql.xql	9 Sep 2001 15:36:44 -0000	1.4
+++ openacs-4/packages/acs-subsite/www/admin/rel-types/new-2-postgresql.xql	4 Dec 2001 00:20:47 -0000	1.5
@@ -10,7 +10,7 @@
            t2.object_type as rel_type
       from acs_object_types t1,
 	   acs_object_types t2
-     where t2.tree_sortkey like (t1.tree_sortkey || '%')
+     where t2.tree_sortkey between t1.tree_sortkey and tree_right(t1.tree_sortkey)
        and t1.object_type = :max_object_type_one
 
       </querytext>
@@ -24,7 +24,7 @@
            t2.object_type as rel_type
       from acs_object_types t1,
 	   acs_object_types t2
-     where t2.tree_sortkey like (t1.tree_sortkey || '%')
+     where t2.tree_sortkey between t1.tree_sortkey and tree_right(t1.tree_sortkey)
        and t1.object_type = :max_object_type_two
 
       </querytext>