Index: openacs-4/packages/acs-content-repository/tcl/filter-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/filter-procs-postgresql.xql,v diff -u -N -r1.14 -r1.15 --- openacs-4/packages/acs-content-repository/tcl/filter-procs-postgresql.xql 7 Aug 2017 23:47:47 -0000 1.14 +++ openacs-4/packages/acs-content-repository/tcl/filter-procs-postgresql.xql 22 Jan 2018 10:43:06 -0000 1.15 @@ -2,23 +2,6 @@ postgresql7.1 - - - - With RECURSIVE child_items AS ( - select 0 as lvl, i.item_id, ''::text as name, i.parent_id, 'Home'::text as title - from cr_items i, cr_revisions r - where i.item_id = :item_id and i.live_revision = r.revision_id - UNION ALL - select child_items.lvl+1, i.item_id, i.name, i.parent_id, r.title - from cr_items i, cr_revisions r, child_items - where i.parent_id = child_items.item_id and i.live_revision = r.revision_id - ) - select * from child_items; - - - -