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