got contact info working

1 files changed, 45 insertions, 0 deletions

diff --git a/sql/functions/resume.insert_contactinfo.sql b/sql/functions/resume.insert_contactinfo.sql
new file mode 100644
index 0000000..428e69b
--- /dev/null
+++ b/sql/functions/resume.insert_contactinfo.sql
@@ -0,0 +1,45 @@
+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;