drop function resume.insert_education (
    p_user_id int,
    p_school character varying,
    p_start_date character varying,
    p_end_date character varying,
    p_major character varying,
    p_minor character varying,
    p_degree character varying,
    p_progress character varying
);

create or replace function resume.insert_education (
    p_user_id int,
    p_school character varying,
    p_start_date character varying,
    p_end_date character varying,
    p_major character varying,
    p_minor character varying,
    p_degree character varying,
    p_progress character varying
)
returns bigint
as $$
declare
  l_id bigint;
begin
    insert into resume.education (
        user_id,
        school,
        start_date,
        end_date,
        major,
        minor,
        degree,
        progress
    ) values (
        p_user_id,
        p_school,
        p_start_date,
        p_end_date,
        p_major,
        p_minor,
        p_degree,
        p_progress
    ) returning id into l_id;

    return l_id;
end;
$$ language plpgsql;