postgresql7.1 select content_revision__new ( :name, -- title :description, -- description :mime_type, -- mime_type :file_id, -- item_id :user_id, -- creation_user :ip_addr -- creation_ip ); update cr_revisions set content = empty_blob() where revision_id = :revision_id returning content into :1 select content_item__set_live_revision(:revision_id);