From 8ab94f4677f8d56655a45bb636917429dcddda24 Mon Sep 17 00:00:00 2001
From: ckonstanski <kostcarl@isu.edu>
Date: Mon, 20 Jul 2026 21:09:54 -0600
Subject: got contact info working

---
 sql/functions/contact.insert_contact_us_post.sql | 10 +---------
 1 file changed, 1 insertion(+), 9 deletions(-)

(limited to 'sql/functions/contact.insert_contact_us_post.sql')

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;
-- 
cgit v1.3