postgresql7.1 select ca__get_folder_id (:package_id) select content_item__get_content_type (:item_id) select content_folder__register_content_type (:folder_id, :content_type, :include_subtypes) select content_folder__new (:name, :label, :description, :root_folder_id) select ca__set_package_folder (:new_folder_id, :package_id) select content_item__new (:name::varchar, :parent_id::int4, :item_id::int4, null, now(), :creation_user, null, :creation_ip, :content_item, :content_type, null, null, 'text/plain', null, null, 'text'::varchar) select content_revision__new (:title, :description, now(), null, null, :data, :item_id, null, now(), :creation_user, :creation_ip) $plsql_query select content_keyword__item_assign (:cr_item_id, :category_id, null, null, null) select content_revision__new (:title, :description, now(), null, null, :data, :item_id, null, now(), :creation_user, :creation_ip) update cr_revisions set title = :title, description = :description, content = :data where revision_id = :object_id $plsql_query select content_item__is_subclass (:content_type, :parent_type) select ca_attributes__add_generic_value (:object_id, :attribute_id, :attr_value) select ca_attributes__edit_generic_value (:object_id, :attribute_id, :attr_value) select content_item__get_latest_revision (:item_id) select content_revision__get_content (:revision_id) select site_node__url(n2.node_id) as url, n2.object_id, acs_object__name(n2.object_id) as object_name, tree_level(n2.tree_sortkey) as level from (select tree_ancestor_keys(site_node_get_tree_sortkey(:node_id)) as tree_sortkey) parents, site_nodes n2 where n2.tree_sortkey = parents.tree_sortkey and tree_level(n2.tree_sortkey) > 1 order by level asc