-- -- acs_sc_msg_type__get_name/1 -- create or replace function acs_sc_msg_type__get_name( integer ) returns varchar as $$ declare p_msg_type_id alias for $1; v_msg_type_name varchar; begin select msg_type_name into v_msg_type_name from acs_sc_msg_types where msg_type_id = p_msg_type_id; return v_msg_type_name; end;$$ language plpgsql;