postgresql 7.4 update as_item_data set clob_answer=:clob_answer where item_data_id=:as_item_data_id select d.item_data_id, d.boolean_answer, d.clob_answer, d.numeric_answer, d.integer_answer, d.text_answer, d.timestamp_answer, d.content_answer, d.points from as_session_item_map m, as_item_data d where d.session_id = :session_id and d.subject_id = :subject_id and d.as_item_id = :as_item_id and m.session_id = d.session_id and m.item_data_id = d.item_data_id order by d.item_data_id desc limit 1