postgresql7.1
select content_keyword__new (:heading,
:description,
:parent_id,
:keyword_id,
now(),
:creation_user,
:creation_ip,
'content_keyword')
select content_keyword__delete (:keyword_id)
select content_keyword__get_heading (:keyword_id)
select content_keyword__set_heading (:keyword_id,
:heading)
select content_keyword__get_description (:keyword_id)
select content_keyword__set_description (:keyword_id,
:description)
select content_keyword__get_path (:keyword_id)
select content_keyword__item_assign (:item_id,
:keyword_id,
null,
null,
null)
select content_keyword__item_unassign (:item_id,
:keyword_id)
SELECT
attribute_name
FROM
acs_attributes att,
ca_attribute_widget_values cawv,
(
select
subtree.keyword_id
from cr_keywords parent, cr_keywords subtree
where parent.keyword_id = :keyword_id
and parent.tree_sortkey between subtree.tree_sortkey and tree_right(subtree.tree_sortkey)
) keywords
WHERE
att.attribute_id = cawv.attribute_id
AND
cawv.keyword_id = keywords.keyword_id