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