diff options
Diffstat (limited to 'sql/functions/resume.insert_resume.sql')
| -rw-r--r-- | sql/functions/resume.insert_resume.sql | 25 |
1 files changed, 0 insertions, 25 deletions
diff --git a/sql/functions/resume.insert_resume.sql b/sql/functions/resume.insert_resume.sql deleted file mode 100644 index 99ac786..0000000 --- a/sql/functions/resume.insert_resume.sql +++ /dev/null @@ -1,25 +0,0 @@ -drop function resume.insert_resume ( - p_user_id int, - p_name character varying -); - -create or replace function resume.insert_resume ( - p_user_id int, - p_name character varying -) -returns bigint -as $$ -declare - l_id bigint; -begin - insert into resume.resume ( - user_id, - name - ) values ( - p_user_id, - p_name - ) returning id into l_id; - - return l_id; -end; -$$ language plpgsql; |
