drop function resume.insert_contactinfo (
    p_user_id int,
    p_state_id bigint,
    p_visastatus_id bigint,
    p_address character varying,
    p_city character varying,
    p_phone character varying,
    p_email character varying
);

create or replace function resume.insert_contactinfo (
    p_user_id int,
    p_state_id bigint,
    p_visastatus_id bigint,
    p_address character varying,
    p_city character varying,
    p_phone character varying,
    p_email character varying
)
returns bigint
as $$
declare
  l_id bigint;
begin
    insert into resume.contactinfo (
        user_id,
        state_id,
        visastatus_id,
        address,
        city,
        phone,
        email
    ) values (
        p_user_id,
        p_state_id,
        p_visastatus_id,
        p_address,
        p_city,
        p_phone,
        p_email
    ) returning id into l_id;

    return l_id;
end;
$$ language plpgsql;