drop function resume.delete_resume (
    p_id bigint
);

create or replace function resume.delete_resume (
    p_id bigint
)
returns void
as $$
begin
    delete from resume.resume_contactinfo
    where resume_id = p_id;

    delete from resume.resume_education
    where resume_id = p_id;

    delete from resume.resume_job
    where resume_id = p_id;

    delete from resume.resume_language
    where resume_id = p_id;

    delete from resume.resume
    where id = p_id;
end;
$$ language plpgsql;