postgresql7.1 declare v_revision_id integer; begin select acs_message__edit ( /* message_id => */ :comment_id, /* title => */ :title, /* p_description */ NULL, /* mime_type => */ :comment_mime_type, /* text */ NULL, /* data => */ NULL, -- was empty_blob(), /* creation_date */ now(), /* creation_user => */ :user_id, /* creation_ip => */ :creation_ip, /* is_live => */ :is_live ) into v_revision_id; return v_revision_id; end; select content_item__get_latest_revision(:comment_id) as revision_id update cr_revisions set content = :content where revision_id = :revision_id