diff options
Diffstat (limited to 'sql/functions/contact.insert_contact_us_post.sql')
| -rw-r--r-- | sql/functions/contact.insert_contact_us_post.sql | 10 |
1 files changed, 1 insertions, 9 deletions
diff --git a/sql/functions/contact.insert_contact_us_post.sql b/sql/functions/contact.insert_contact_us_post.sql index 739f084..7ca4495 100644 --- a/sql/functions/contact.insert_contact_us_post.sql +++ b/sql/functions/contact.insert_contact_us_post.sql @@ -30,15 +30,7 @@ begin p_email, p_phone, p_comments - ); - - select id into l_id - from contact.contact_us_posts - where first_name = p_first_name - and last_name = p_last_name - and email = p_email - and phone = p_phone - and comments = p_comments; + ) returning id into l_id; return l_id; end; |
