From f7feb024caeeb973b1cbd35b2b96d67f0c743195 Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc" <kop@karlpinc.com>
Date: Tue, 3 Oct 2023 21:58:09 -0500
Subject: [PATCH] Fix trigger RETURN statements

---
 db/schemas/lookup/triggers/create/comm_ids.m4    | 4 ++--
 db/schemas/lookup/triggers/create/departtypes.m4 | 4 ++--
 db/schemas/sokwedb/triggers/create/biography.m4  | 4 ++--
 db/schemas/sokwedb/triggers/create/comm_membs.m4 | 2 +-
 4 files changed, 7 insertions(+), 7 deletions(-)

diff --git a/db/schemas/lookup/triggers/create/comm_ids.m4 b/db/schemas/lookup/triggers/create/comm_ids.m4
index a18a291..5a9c239 100644
--- a/db/schemas/lookup/triggers/create/comm_ids.m4
+++ b/db/schemas/lookup/triggers/create/comm_ids.m4
@@ -38,7 +38,7 @@ CREATE OR REPLACE FUNCTION comm_ids_func ()
     restrict_special_row(`COMM_IDS', `CommID', sdb_unknown_comm)
   END IF;
 
-  RETURN;
+  RETURN NULL;
   END;
 $$;
 
@@ -51,7 +51,7 @@ CREATE OR REPLACE FUNCTION comm_ids_delete_func ()
   BEGIN
   restrict_delete(`COMM_IDS', `CommID', sdb_unknown_comm)
 
-  RETURN;
+  RETURN NULL;
   END;
 $$;
 
diff --git a/db/schemas/lookup/triggers/create/departtypes.m4 b/db/schemas/lookup/triggers/create/departtypes.m4
index 254a9dd..1b75c8e 100644
--- a/db/schemas/lookup/triggers/create/departtypes.m4
+++ b/db/schemas/lookup/triggers/create/departtypes.m4
@@ -38,7 +38,7 @@ CREATE OR REPLACE FUNCTION departtypes_func ()
     restrict_special_row(`DEPARTTYPES', `CommID', sdb_end_of_obs)
   END IF;
 
-  RETURN;
+  RETURN NULL;
   END;
 $$;
 
@@ -51,7 +51,7 @@ CREATE OR REPLACE FUNCTION departtypes_delete_func ()
   BEGIN
   restrict_delete(`DEPARTTYPES', `CommID', sdb_end_of_obs)
 
-  RETURN;
+  RETURN NULL;
   END;
 $$;
 
diff --git a/db/schemas/sokwedb/triggers/create/biography.m4 b/db/schemas/sokwedb/triggers/create/biography.m4
index d61477d..61e80f5 100644
--- a/db/schemas/sokwedb/triggers/create/biography.m4
+++ b/db/schemas/sokwedb/triggers/create/biography.m4
@@ -360,7 +360,7 @@ CREATE OR REPLACE FUNCTION biography_func ()
     END IF;
   END;
 
-  RETURN;
+  RETURN NULL;
   END;
 $$;
 
@@ -384,7 +384,7 @@ CREATE OR REPLACE FUNCTION biography_delete_func ()
   -- must have FirstBorn of sdb_not_firstborn.
   check_firstborn(`OLD', `Deleting the BIOGRAPHY row')
 
-  RETURN;
+  RETURN NULL;
   END;
 $$;
 
diff --git a/db/schemas/sokwedb/triggers/create/comm_membs.m4 b/db/schemas/sokwedb/triggers/create/comm_membs.m4
index f78cdb3..f4f6133 100644
--- a/db/schemas/sokwedb/triggers/create/comm_membs.m4
+++ b/db/schemas/sokwedb/triggers/create/comm_membs.m4
@@ -174,7 +174,7 @@ CREATE OR REPLACE FUNCTION comm_membs_func ()
     END IF;
   END;
 
-  RETURN;
+  RETURN NULL;
   END;
 $$;
 
-- 
2.34.1