postgresql7.1 select bookmark_id, local_title, tree_level(tree_sortkey) as indentation from bm_bookmarks where tree_sortkey like ( select tree_sortkey || ''%'' from bm_bookmarks where parent_id = :package_id ) and folder_p = 't' and owner_id = :user_id and bookmark_id <> :bookmark_id and parent_id <> :package_id and acs_permission__permission_p(bookmark_id, :user_id, 'write') = 't' $exclude_folders order by tree_sortkey select bookmark__get_root_folder (:package_id, :user_id); select count(*) from bm_bookmarks where owner_id = :viewed_user_id and folder_p = 't' and acs_permission__permission_p(bookmark_id, :browsing_user_id, 'write') = 't' select count(*) from bm_bookmarks where tree_sortkey like ( select tree_sortkey || ''%'' from bm_bookmarks where bookmark_id = :bookmark_id ) and acs_permission__permission_p(bookmark_id, :browsing_user_id, 'delete') = 'f' order by tree_sortkey select bookmark__private_p(:bookmark_id) select bookmark__update_private_p(:bookmark_id, :private_p) select bookmark__initialize_in_closed_p (:viewed_user_id, :in_closed_p_id);