-- -- acs_message__edit_file/9 -- create or replace function acs_message__edit_file( integer, character varying, text, character varying, integer, timestamp with time zone, integer, character varying, boolean ) returns int4 as $$ declare p_file_id alias for $1; p_title alias for $2; -- default null p_description alias for $3; -- default null p_mime_type alias for $4; -- default 'text/plain' p_data alias for $5; -- default null p_creation_date alias for $6; -- default sysdate p_creation_user alias for $7; -- default null p_creation_ip alias for $8; -- default null p_is_live alias for $9; -- default 't' v_revision_id cr_revisions.revision_id%TYPE; begin v_revision_id := content_revision__new ( p_title, -- title p_description, current_timestamp, p_mime_type, -- mime_type NULL, p_data, -- data p_file_id, -- item_id NULL, p_creation_date, -- creation_date p_creation_user, -- creation_user p_creation_ip -- creation_ip ); -- test for auto approval of revision if p_is_live then perform content_item__set_live_revision(v_revision_id); end if; return v_revision_id; end;$$ language plpgsql;