summaryrefslogtreecommitdiff
path: root/sql/functions/resume.insert_resume.sql
diff options
context:
space:
mode:
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;