1 files changed, 26 insertions, 0 deletions
diff --git a/sql/functions/resume.delete_resume.sql b/sql/functions/resume.delete_resume.sql
new file mode 100644
index 0000000..9a3c06f
--- /dev/null
+++ b/sql/functions/resume.delete_resume.sql
@@ -0,0 +1,26 @@
+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;