diff options
Diffstat (limited to 'sql/functions/resume.insert_resume.sql')
| -rw-r--r-- | sql/functions/resume.insert_resume.sql | 7 |
1 files changed, 1 insertions, 6 deletions
diff --git a/sql/functions/resume.insert_resume.sql b/sql/functions/resume.insert_resume.sql index eb56897..99ac786 100644 --- a/sql/functions/resume.insert_resume.sql +++ b/sql/functions/resume.insert_resume.sql @@ -18,12 +18,7 @@ begin ) values ( p_user_id, p_name - ); - - select id into l_id - from resume.resume - where user_id = p_user_id - and name = p_name; + ) returning id into l_id; return l_id; end; |
