From 7a902d7dec9e0ea2a35610bebac2e217340deb40 Mon Sep 17 00:00:00 2001 From: ckonstanski Date: Wed, 22 Jul 2026 22:41:16 -0600 Subject: stuff --- sql/functions/resume.insert_education.sql | 49 ------------------------------- 1 file changed, 49 deletions(-) delete mode 100644 sql/functions/resume.insert_education.sql (limited to 'sql/functions/resume.insert_education.sql') diff --git a/sql/functions/resume.insert_education.sql b/sql/functions/resume.insert_education.sql deleted file mode 100644 index 59ba98b..0000000 --- a/sql/functions/resume.insert_education.sql +++ /dev/null @@ -1,49 +0,0 @@ -drop function resume.insert_education ( - p_user_id int, - p_school character varying, - p_start_date character varying, - p_end_date character varying, - p_major character varying, - p_minor character varying, - p_degree character varying, - p_progress character varying -); - -create or replace function resume.insert_education ( - p_user_id int, - p_school character varying, - p_start_date character varying, - p_end_date character varying, - p_major character varying, - p_minor character varying, - p_degree character varying, - p_progress character varying -) -returns bigint -as $$ -declare - l_id bigint; -begin - insert into resume.education ( - user_id, - school, - start_date, - end_date, - major, - minor, - degree, - progress - ) values ( - p_user_id, - p_school, - p_start_date, - p_end_date, - p_major, - p_minor, - p_degree, - p_progress - ) returning id into l_id; - - return l_id; -end; -$$ language plpgsql; -- cgit v1.3