-- -- acs_message__edit_image/11 -- create or replace function acs_message__edit_image( integer, character varying, text, character varying, integer, integer, integer, timestamp with time zone, integer, character varying, boolean ) returns int4 as $$ declare p_image_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_width alias for $6; -- default null p_height alias for $7; -- default null p_creation_date alias for $8; -- default sysdate p_creation_user alias for $9; -- default null p_creation_ip alias for $10; -- default null p_is_live alias for $11; -- default 't' v_revision_id cr_revisions.revision_id%TYPE; begin -- not sure which __new to use v_revision_id := content_revision__new ( p_title, -- title NULL, -- description current_timestamp, -- publish_date p_mime_type, -- mime_type NULL, -- nls_language p_data, -- data p_image_id, -- item_id NULL, -- revision_id p_creation_date, -- creation_date p_creation_user, -- creation_user p_creation_ip -- creation_ip ); -- insert new width and height values -- XXX fix after image.new exists insert into images (image_id, width, height) values (v_revision_id, p_width, p_height); -- 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;