Index: openacs-4/packages/cms/www/modules/items/relate-items-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/items/relate-items-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/cms/www/modules/items/relate-items-postgresql.xql	30 May 2001 22:56:27 -0000	1.2
+++ openacs-4/packages/cms/www/modules/items/relate-items-postgresql.xql	8 Dec 2001 01:18:00 -0000	1.3
@@ -25,10 +25,9 @@
       lpad(' ', tree_level(tree_sortkey), '-') || pretty_name as pretty_name, 
       object_type
     from
-      acs_object_types
-    where 
-      tree_sortkey like (select tree_sortkey || '%'
-                         from acs_object_types where object_type = 'cr_item_rel')
+      acs_object_types ot1, acs_object_types ot2
+    where ot2.object_type = 'cr_item_rel'
+      and ot1.tree_sortkey between ot2.tree_sortkey and tree_right(ot2.tree_sortkey)
 
       </querytext>
 </fullquery>