-- -- acs_sc_msg_type__get_id/1 -- create or replace function acs_sc_msg_type__get_id( character varying ) returns int4 as $$ declare p_msg_type_name alias for $1; v_msg_type_id integer; begin select msg_type_id into v_msg_type_id from acs_sc_msg_types where msg_type_name = p_msg_type_name; return v_msg_type_id; end;$$ language plpgsql;