summaryrefslogtreecommitdiff
path: root/sql/functions/resume.insert_language.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/functions/resume.insert_language.sql')
-rw-r--r--sql/functions/resume.insert_language.sql45
1 files changed, 0 insertions, 45 deletions
diff --git a/sql/functions/resume.insert_language.sql b/sql/functions/resume.insert_language.sql
deleted file mode 100644
index 92ce6b9..0000000
--- a/sql/functions/resume.insert_language.sql
+++ /dev/null
@@ -1,45 +0,0 @@
-drop function resume.insert_language (
- p_user_id int,
- p_name character varying,
- p_understanding_listening character varying,
- p_understanding_reading character varying,
- p_speaking_interaction character varying,
- p_speaking_production character varying,
- p_writing character varying
-);
-
-create or replace function resume.insert_language (
- p_user_id int,
- p_name character varying,
- p_understanding_listening character varying,
- p_understanding_reading character varying,
- p_speaking_interaction character varying,
- p_speaking_production character varying,
- p_writing character varying
-)
-returns bigint
-as $$
-declare
- l_id bigint;
-begin
- insert into resume.language (
- user_id,
- name,
- understanding_listening,
- understanding_reading,
- speaking_interaction,
- speaking_production,
- writing
- ) values (
- p_user_id,
- p_name,
- p_understanding_listening,
- p_understanding_reading,
- p_speaking_interaction,
- p_speaking_production,
- p_writing
- ) returning id into l_id;
-
- return l_id;
-end;
-$$ language plpgsql;