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 -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 @@
- 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
- 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