summaryrefslogtreecommitdiff
path: root/sql/functions/resume.insert_resume.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_resume.sql
parent51aa4409c58625687445f3d176e3f6bfa5281153 (diff)
stuff
Diffstat (limited to 'sql/functions/resume.insert_resume.sql')
-rw-r--r--sql/functions/resume.insert_resume.sql25
1 files changed, 0 insertions, 25 deletions
diff --git a/sql/functions/resume.insert_resume.sql b/sql/functions/resume.insert_resume.sql
deleted file mode 100644
index 99ac786..0000000
--- a/sql/functions/resume.insert_resume.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-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
- ) returning id into l_id;
-
- return l_id;
-end;
-$$ language plpgsql;