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.1 -r1.2
--- openacs-4/packages/cms/www/modules/types/index-postgresql.xql	25 May 2001 23:49:05 -0000	1.1
+++ openacs-4/packages/cms/www/modules/types/index-postgresql.xql	30 May 2001 22:56:27 -0000	1.2
@@ -5,8 +5,6 @@
 
 <fullquery name="get_content_type">      
       <querytext>
-      FIX ME CONNECT BY
-FIX ME ROWNUM
 
   select 
     case when ot2.supertype = 'acs_object' then '' else ot2.supertype end as parent_type,   
@@ -21,16 +19,14 @@
     ot2.tree_sortkey <= ot1.tree_sortkey
   and 
     ot1.tree_sortkey like (ot2.tree_sortkey || '%')
-  order by ot2.tree_sortkey desc
+  order by ot2.tree_sortkey asc
 
       </querytext>
 </fullquery>
 
  
 <fullquery name="get_attr_types">      
       <querytext>
-      FIX ME CONNECT BY
-FIX ME OUTER JOIN
 
   select 
     attr.attribute_id, attr.attribute_name, attr.object_type,
@@ -71,7 +67,7 @@
       template_id,:root_id) as path,
     (select pretty_name 
        from acs_object_types 
-       where object_type = :content_type) pretty_name
+       where object_type = :content_type) as pretty_name
   from 
     cr_type_template_map ttmap, cr_items i 
   where