postgresql7.3
select content_revision__get_content(ets.solution_id) as content,
crr.title,
crr.item_id,
cri.storage_type,
crr.revision_id,
crr.content_length,
ets.mime_type
from evaluation_tasks_solsi ets, cr_items cri, cr_revisions crr
where ets.solution_id = :solution_id
and ets.solution_id = crr.revision_id
and crr.item_id = cri.item_id
select solution_id
from evaluation_tasks_sols
where task_item_id = :task_item_id
and content_revision__is_live(solution_id) = true
content_revision__content_copy(:solution_id, :revision_id)
update cr_revisions
set lob = [set __lob_id [db_string get_lob_id "select empty_lob()"]]
where revision_id = :revision_id
update cr_items
set storage_type = 'text'
where item_id = :item_id
update cr_revisions
set content = :url
where revision_id = :revision_id
update cr_revisions
set content = :file_name,
mime_type = :mime_type,
content_length = :content_length
where revision_id = :revision_id