got contact info working

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;