Index: openacs-4/packages/cms/www/modules/types/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/types/index-postgresql.xql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/cms/www/modules/types/index-postgresql.xql	8 Jun 2001 01:44:53 -0000	1.3
+++ openacs-4/packages/cms/www/modules/types/index-postgresql.xql	8 Dec 2001 01:18:00 -0000	1.4
@@ -15,10 +15,8 @@
     acs_object_types ot2
   where
     ot2.object_type != 'acs_object'
-  and
-    ot2.tree_sortkey <= ot1.tree_sortkey
   and 
-    ot1.tree_sortkey like (ot2.tree_sortkey || '%')
+    ot1.tree_sortkey between ot2.tree_sortkey and tree_right(ot2.tree_sortkey)
   order by ot2.tree_sortkey asc
 
       </querytext>
@@ -45,9 +43,7 @@
       where 
         o2.object_type != 'acs_object'
       and 
-        o2.tree_sortkey <= o1.tree_sortkey
-      and 
-        o1.tree_sortkey like (o2.tree_sortkey || '%')
+        o1.tree_sortkey between o2.tree_sortkey and tree_right(o2.tree_sortkey)
     ) types        
   where 
     attr.object_type = types.object_type