From 7a902d7dec9e0ea2a35610bebac2e217340deb40 Mon Sep 17 00:00:00 2001
From: ckonstanski <kostcarl@isu.edu>
Date: Wed, 22 Jul 2026 22:41:16 -0600
Subject: stuff

---
 sql/functions/resume.insert_contactinfo.sql | 45 -----------------------------
 1 file changed, 45 deletions(-)
 delete mode 100644 sql/functions/resume.insert_contactinfo.sql

(limited to 'sql/functions/resume.insert_contactinfo.sql')

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;
-- 
cgit v1.3