Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql,v diff -u -r1.23 -r1.24 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql 16 Jul 2001 23:46:08 -0000 1.23 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql 23 Aug 2001 02:26:21 -0000 1.24 @@ -1074,6 +1074,7 @@ -- first. I suspect that it is not functioning correctly. while v_parent_id = v_rel_parent_id LOOP + -- c_abs_cur select name, parent_id, tree_level(tree_sortkey) into @@ -1091,6 +1092,7 @@ v_item_id := v_parent_id; end if; + -- c_rel_cur select parent_id, tree_level(tree_sortkey) as tree_level into