drop function resume.insert_language (
    p_user_id int,
    p_name character varying,
    p_understanding_listening character varying,
    p_understanding_reading character varying,
    p_speaking_interaction character varying,
    p_speaking_production character varying,
    p_writing character varying
);

create or replace function resume.insert_language (
    p_user_id int,
    p_name character varying,
    p_understanding_listening character varying,
    p_understanding_reading character varying,
    p_speaking_interaction character varying,
    p_speaking_production character varying,
    p_writing character varying
)
returns bigint
as $$
declare
  l_id bigint;
begin
    insert into resume.language (
        user_id,
        name,
        understanding_listening,
        understanding_reading,
        speaking_interaction,
        speaking_production,
        writing
    ) values (
        p_user_id,
        p_name,
        p_understanding_listening,
        p_understanding_reading,
        p_speaking_interaction,
        p_speaking_production,
        p_writing
    ) returning id into l_id;

    return l_id;
end;
$$ language plpgsql;