-- -- acs_sc_msg_type__new_element/5 -- create or replace function acs_sc_msg_type__new_element( character varying, character varying, character varying, boolean, integer ) returns int4 as $$ declare p_msg_type_name alias for $1; p_element_name alias for $2; p_element_msg_type_name alias for $3; p_element_msg_type_isset_p alias for $4; p_element_pos alias for $5; v_msg_type_id integer; v_element_msg_type_id integer; begin v_msg_type_id := acs_sc_msg_type__get_id(p_msg_type_name); if v_msg_type_id is null then raise exception 'Unknown Message Type: %', p_msg_type_name; end if; v_element_msg_type_id := acs_sc_msg_type__get_id(p_element_msg_type_name); if v_element_msg_type_id is null then raise exception 'Unknown Message Type: %', p_element_msg_type_name; end if; insert into acs_sc_msg_type_elements ( msg_type_id, element_name, element_msg_type_id, element_msg_type_isset_p, element_pos ) values ( v_msg_type_id, p_element_name, v_element_msg_type_id, p_element_msg_type_isset_p, p_element_pos ); return v_msg_type_id; end;$$ language plpgsql;