-- -- acs_sc_msg_type__delete/1 -- create or replace function acs_sc_msg_type__delete( integer ) returns int4 as $$ declare p_msg_type_id alias for $1; begin delete from acs_sc_msg_types where msg_type_id = p_msg_type_id; return 0; end;$$ language plpgsql; -- -- acs_sc_msg_type__delete/1 -- create or replace function acs_sc_msg_type__delete( character varying ) returns int4 as $$ declare p_msg_type_name alias for $1; v_msg_type_id integer; begin v_msg_type_id := acs_sc_msg_type__get_id(p_msg_type_name); perform acs_sc_msg_type__delete(v_msg_type_id); return v_msg_type_id; end;$$ language plpgsql;