From e7301bcd63c0cbfc4d55f21d0d7c33c7557d6444 Mon Sep 17 00:00:00 2001
From: ckonstanski <kostcarl@isu.edu>
Date: Sun, 19 Jul 2026 22:05:02 -0600
Subject: starting resume logic

---
 sql/functions/resume.insert_resume.sql | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)
 create mode 100644 sql/functions/resume.insert_resume.sql

(limited to 'sql/functions')

diff --git a/sql/functions/resume.insert_resume.sql b/sql/functions/resume.insert_resume.sql
new file mode 100644
index 0000000..eb56897
--- /dev/null
+++ b/sql/functions/resume.insert_resume.sql
@@ -0,0 +1,30 @@
+drop function resume.insert_resume (
+    p_user_id int,
+    p_name character varying
+);
+
+create or replace function resume.insert_resume (
+    p_user_id int,
+    p_name character varying
+)
+returns bigint
+as $$
+declare
+  l_id bigint;
+begin
+    insert into resume.resume (
+        user_id,
+        name
+    ) values (
+        p_user_id,
+        p_name
+    );
+
+    select id into l_id
+    from resume.resume
+    where user_id = p_user_id
+        and name = p_name;
+
+    return l_id;
+end;
+$$ language plpgsql;
-- 
cgit v1.3