From 51354fd19f76c2cbfd31542e9c072b86a90134f0 Mon Sep 17 00:00:00 2001
From: ckonstanski <kostcarl@isu.edu>
Date: Tue, 21 Jul 2026 15:26:40 -0600
Subject: added education

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

(limited to 'sql/functions/resume.insert_education.sql')

diff --git a/sql/functions/resume.insert_education.sql b/sql/functions/resume.insert_education.sql
new file mode 100644
index 0000000..59ba98b
--- /dev/null
+++ b/sql/functions/resume.insert_education.sql
@@ -0,0 +1,49 @@
+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;
-- 
cgit v1.3