postgresql7.2 select content_template__new(:template_name, :parent_id, null, now(), :creation_user_id, :creation_ip) select content_revision__new(:title, :description, now(), 'text/html', null, :content, :template_id, null, now(), :creation_user_id, :creation_ip) select content_template__delete(:template_id) select content_template__get_root_folder() select content_item__register_template(:item_id, :template_id, :context) select content_type__register_template( :content_type, :template_id, :context, :is_default_p) select content_item__unregister_template(:item_id, :template_id, :context) select name, item_id from cr_items where item_id = content_item__get_template(:item_id, :context) select i.item_id as template_id, i.name, i.live_revision, i.latest_revision, i.publish_status, i.content_type, i.storage_type, i.tree_sortkey, r.title, r.description from cr_items i, cr_revisions r where i.parent_id = :parent_id and i.item_id = r.item_id and r.revision_id = $revision