From b8423f4d05c75094b7b9d09c6f0bb353acc9be1c Mon Sep 17 00:00:00 2001
From: ckonstanski <carlos.konstanski@olo.com>
Date: Sat, 25 May 2024 18:03:25 -0600
Subject: initial commit

---
 sql/functions/auth.delete_registration.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 sql/functions/auth.delete_registration.sql

(limited to 'sql/functions/auth.delete_registration.sql')

diff --git a/sql/functions/auth.delete_registration.sql b/sql/functions/auth.delete_registration.sql
new file mode 100644
index 0000000..5adf705
--- /dev/null
+++ b/sql/functions/auth.delete_registration.sql
@@ -0,0 +1,14 @@
+drop function auth.delete_registration (
+    p_hash text
+);
+
+create or replace function auth.delete_registration (
+    p_hash text
+)
+returns void
+as $$
+begin
+    delete from auth.registrations r
+    where r.hash = ('\x' || p_hash)::bytea;
+end;
+$$ language plpgsql;
-- 
cgit v1.3