postgresql7.1
select etp__create_symlink(:package_id, :target_id);
select i.item_id, i.name, etp__get_title(i.item_id, null) as title,
repeat(' ',(tree_level(i.tree_sortkey) - 1) * 4) as indent
from cr_items i, acs_objects o, cr_items i2
where i.item_id = o.object_id
and o.object_type in ('content_item', 'content_folder')
and i.name != 'index'
and i2.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