postgresql 7.3 update cr_revisions set content=:content where revision_id=:revision_id select item_id from cr_revisions where revision_id = :revision_id update cr_revisions set mime_type = :mime_type, lob = [set __lob_id [db_string get_lob_id {select empty_lob()}]] where revision_id = :revision_id update cr_revisions set content_length = lob_length(lob) where revision_id = :revision_id update cr_revisions set content = :filename, mime_type = :mime_type, content_length = :tmp_size where revision_id = :revision_id select storage_area_key, content as filename from cr_items ci, cr_revisions cr where cr.item_id=ci.item_id and cr.revision_id=:revision_id