postgresql7.2 select content_item__get_root_folder(null); select f.folder_id, i.name, i.parent_id, f.label, f.has_child_folders, f.has_child_symlinks, f.package_id from cr_items i, cr_folders f where f.folder_id = i.item_id and i.parent_id = :parent_id order by i.tree_sortkey select f.folder_id, i.name, i.parent_id, f.label, f.has_child_folders, f.has_child_symlinks, f.package_id, tree_level(i.tree_sortkey) as level, tree_level(p.tree_sortkey) as parent_level, :prepend_path || content_item__get_path(f.folder_id, p.item_id) as path from cr_items i, cr_folders f, (select item_id, tree_sortkey from cr_items where item_id = :parent_id) p where f.folder_id = i.item_id and i.tree_sortkey between p.tree_sortkey and tree_right(p.tree_sortkey) $addtnl_where order by i.tree_sortkey select content_folder__delete(:folder_id,:cascade_p) select content_folder__register_content_type ( :folder_id, :content_type, :subtypes_p ) select content_folder__is_registered (:folder_id, :content_type, 'f');