postgresql7.4 select crr.title, crr.item_id from evaluation_tasks_sols ets, cr_revisions crr where ets.solution_id = :solution_id and crr.revision_id = ets.solution_id update cr_revisions set lob = [set __lob_id [db_string get_lob_id "select empty_lob()"]] where revision_id = :revision_id update cr_revisions set content = :url where revision_id = :revision_id delete from evaluation_tasks_sols where task_id=:task_id