postgresql7.3 select evaluation__party_id(:user_id,:task_id) select task_item_id, task_name from evaluation_tasks where task_id = :task_id select answer_id from evaluation_answers where party_id = :party_id and task_item_id = :task_item_id and content_revision__is_live(answer_id) = true select late_submit_p from evaluation_tasks where task_id = :task_id select 1 from evaluation_tasks where task_id = :task_id and due_date < now() select crr.title, crr.item_id from evaluation_answers ea, cr_revisions crr where ea.answer_id = :answer_id and crr.revision_id = ea.answer_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