postgresql7.4 select grade_plural_name, weight as grade_weight from evaluation_grades where grade_id = :grade_id select content_revision__get_content(et.revision_id) as content, et.title, et.item_id, cri.storage_type from evaluation_tasksi et, cr_items cri where et.task_id = :task_id and et.item_id = cri.item_id select et.task_name, et.description, to_char(et.due_date,'YYYY-MM-DD HH24:MI:SS') as due_date, et.weight, et.number_of_members, et.online_p, et.late_submit_p, et.requires_grade_p from evaluation_tasksi et where task_id = :task_id select [template::util::date::get_property sql_date $due_date] from dual 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 update cr_revisions set content_length = :content_length where revision_id = :revision_id content_revision__content_copy(:task_id, :revision_id)