postgresql7.1 select content_template__get_root_folder() select content_item__get_id(:url, :content_root, 'f') as item_id select i.ims_item_id as imsitem_id from ims_cp_items_to_resources i, ims_cp_files f where f.file_id=:file_id and i.res_id=f.res_id;