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