summaryrefslogtreecommitdiff
path: root/sql/functions/resume.insert_education.sql
diff options
context:
space:
mode:
authorckonstanski <kostcarl@isu.edu>2026-07-22 22:41:16 -0600
committerckonstanski <kostcarl@isu.edu>2026-07-22 22:41:16 -0600
commit7a902d7dec9e0ea2a35610bebac2e217340deb40 (patch)
tree986111ad86ec227edc7f4b12e542a2ff0c2bcee5 /sql/functions/resume.insert_education.sql
parent51aa4409c58625687445f3d176e3f6bfa5281153 (diff)
stuff
Diffstat (limited to 'sql/functions/resume.insert_education.sql')
-rw-r--r--sql/functions/resume.insert_education.sql49
1 files changed, 0 insertions, 49 deletions
diff --git a/sql/functions/resume.insert_education.sql b/sql/functions/resume.insert_education.sql
deleted file mode 100644
index 59ba98b..0000000
--- a/sql/functions/resume.insert_education.sql
+++ /dev/null
@@ -1,49 +0,0 @@
-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;