postgresql7.1 select category_tree__map( :object_id, :tree_id, :subtree_category_id, :assign_single_p, :require_category_p, :widget ) select category_tree__unmap(:object_id,:tree_id) select category_tree__copy(:source_tree, :dest_tree, :creation_user, :creation_ip) select category_tree__new ( :tree_id, :locale, :name, :description, :site_wide_p, current_timestamp, :user_id, :creation_ip, :context_id ) select category_tree__new_translation ( :tree_id, :default_locale, :name, :description, current_timestamp, :user_id, :creation_ip ) select category_tree__new_translation ( :tree_id, :locale, :name, :description, current_timestamp, :user_id, :modifying_ip ) select category_tree__edit ( :tree_id, :locale, :name, :description, :site_wide_p, current_timestamp, :user_id, :modifying_ip ) select category_tree__del ( :tree_id ) select t.pretty_plural, n.object_id, n.title, p.package_id, p.instance_name, acs_permission__permission_p(n.object_id, :user_id, 'read') as read_p from category_tree_map m, acs_objects n, apm_packages p, apm_package_types t where m.tree_id = :tree_id and n.object_id = m.object_id and p.package_id = n.package_id and t.package_key = p.package_key