Index: openacs-4/packages/lorsm/tcl/lorsm-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/tcl/lorsm-procs-postgresql.xql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/lorsm/tcl/lorsm-procs-postgresql.xql 12 Dec 2008 14:25:33 -0000 1.2 +++ openacs-4/packages/lorsm/tcl/lorsm-procs-postgresql.xql 26 Jun 2015 08:51:25 -0000 1.3 @@ -2,24 +2,6 @@ postgresql7.1 - - - select 0 as tree_level, '' as name , 'Home' as title - union - select t.tree_level, i.name, content_item.get_title(t.context_id) as title - from (select o2.context_id, tree_level(o2.tree_sortkey) as tree_level - from ( select * - from acs_objects - where object_id = :item_id ) - o1, acs_objects o2 - where context_id <> content_item__get_root_folder() - and o1.tree_sortkey between o2.tree_sortkey - and tree_right(o2.tree_sortkey)) t, cr_items i - where i.item_id = t.context_id - order by tree_level - - - select 1