postgresql7.1
and bookmark_id not in
(
select bookmark_id from bm_bookmarks
where folder_p = 't'
and owner_id = :user_id
and tree_sortkey like
(
select tree_sortkey || '%'
from bm_bookmarks
where parent_id = :package_id
)
order by tree_sortkey
)
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);