Index: openacs.org-dev/packages/edit-this-page/www/etp-symlink-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/edit-this-page/www/etp-symlink-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs.org-dev/packages/edit-this-page/www/etp-symlink-postgresql.xql 9 Jul 2002 17:35:08 -0000 1.1 +++ openacs.org-dev/packages/edit-this-page/www/etp-symlink-postgresql.xql 29 Aug 2002 05:13:27 -0000 1.2 @@ -16,9 +16,8 @@ where i.item_id = o.object_id and o.object_type in ('content_item', 'content_folder') and i.name != 'index' - and i.tree_sortkey not like (select tree_sortkey - from cr_items - where item_id = -400) || '%' + and tree_root_key(i.tree_sortkey) <> + (select tree_sortkey from cr_items where item_id=-400) order by i.tree_sortkey