Index: openacs-4/packages/acs-subsite/www/admin/relations/add-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/relations/Attic/add-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-subsite/www/admin/relations/add-postgresql.xql	11 Aug 2001 21:31:03 -0000	1.2
+++ openacs-4/packages/acs-subsite/www/admin/relations/add-postgresql.xql	4 Dec 2001 00:20:47 -0000	1.3
@@ -18,8 +18,7 @@
 	      	select t2.object_type from 
 		acs_object_types t1, acs_object_types t2
 		where t1.object_type= :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)
 	)
 
       </querytext>
@@ -44,10 +43,9 @@
                    p.party_id
             from (select o.object_id as party_id
                   from acs_objects o,
-                       (select object_type from acs_object_types
-                        where tree_sortkey like (select tree_sortkey || '%'
-						from acs_object_types
-						where $start_with)) t
+                       (select object_type from acs_object_types ot, acs_object_types ot2
+                        where ot.tree_sortkey between ot2.tree_sortkey and tree_right(ot2.tree_sortkey)
+                          and $start_with)) t
                   where o.object_type = t.object_type) p left join
                  (select element_id
                   from group_element_map