postgresql7.1 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_length = lob_length(lob) 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 select acs_rel__new ( null, 'email_image_rel', :user_id, :item_id, null, null, null )