diff options
| author | ckonstanski <kostcarl@isu.edu> | 2026-07-20 21:09:54 -0600 |
|---|---|---|
| committer | ckonstanski <kostcarl@isu.edu> | 2026-07-20 21:09:54 -0600 |
| commit | 8ab94f4677f8d56655a45bb636917429dcddda24 (patch) | |
| tree | b8481a5b04eca19fca1056340e35f1d6665a4fbd /sql/functions/resume.insert_resume.sql | |
| parent | 9486b95432298bc89f6d7e4639721fb4e49879e0 (diff) | |
got contact info working
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; |