diff options
| author | ckonstanski <kostcarl@isu.edu> | 2026-07-22 22:41:16 -0600 |
|---|---|---|
| committer | ckonstanski <kostcarl@isu.edu> | 2026-07-22 22:41:16 -0600 |
| commit | 7a902d7dec9e0ea2a35610bebac2e217340deb40 (patch) | |
| tree | 986111ad86ec227edc7f4b12e542a2ff0c2bcee5 /sql/functions/resume.insert_language.sql | |
| parent | 51aa4409c58625687445f3d176e3f6bfa5281153 (diff) | |
stuff
Diffstat (limited to 'sql/functions/resume.insert_language.sql')
| -rw-r--r-- | sql/functions/resume.insert_language.sql | 45 |
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; |
