stuff

1 files changed, 0 insertions, 45 deletions

diff --git a/sql/functions/resume.insert_contactinfo.sql b/sql/functions/resume.insert_contactinfo.sql
deleted file mode 100644
index 428e69b..0000000
--- a/sql/functions/resume.insert_contactinfo.sql
+++ /dev/null
@@ -1,45 +0,0 @@
-drop function resume.insert_contactinfo (
-    p_user_id int,
-    p_state_id bigint,
-    p_visastatus_id bigint,
-    p_address character varying,
-    p_city character varying,
-    p_phone character varying,
-    p_email character varying
-);
-
-create or replace function resume.insert_contactinfo (
-    p_user_id int,
-    p_state_id bigint,
-    p_visastatus_id bigint,
-    p_address character varying,
-    p_city character varying,
-    p_phone character varying,
-    p_email character varying
-)
-returns bigint
-as $$
-declare
-  l_id bigint;
-begin
-    insert into resume.contactinfo (
-        user_id,
-        state_id,
-        visastatus_id,
-        address,
-        city,
-        phone,
-        email
-    ) values (
-        p_user_id,
-        p_state_id,
-        p_visastatus_id,
-        p_address,
-        p_city,
-        p_phone,
-        p_email
-    ) returning id into l_id;
-
-    return l_id;
-end;
-$$ language plpgsql;