Changes between Version 19 and Version 20 of DatabaseProgramming

Timestamp:

06/11/26 11:14:12 (5 days ago)

Author:

231028

Comment:

--

DatabaseProgramming

@@ -707 +707 @@
     execute function enforce_offer_validity();
 }}}
+
+{{{
+create or replace function unique_email_and_phone()
+returns trigger
+as
+    $$
+    begin
+        if exists(
+            select 1
+            from appuser
+            where appuser.email=NEW.email
+        ) then
+            raise exception 'User with this email already exists';
+        end if ;
+        if exists(
+            select 1
+            from appuser
+            where appuser.phone_number=NEW.phone_number
+        ) then
+            raise exception 'User with this phone number already exists';
+        end if ;
+    end;
+    $$;
+create trigger check_valid_email_and_phone_number
+before insert on Appuser
+for each row
+execute function unique_email_and_phone()
+}}}