Updated insertsteward, got it working.

SimonGoring · SimonGoring · commit f86f6b5aa703 · 2020-06-23T15:32:40.000-07:00
diff --git a/function/ts/insertsteward.sql b/function/ts/insertsteward.sql
@@ -13,12 +13,8 @@ AS $function$
   WITH newstew AS (
     SELECT stewardid,
       _databaseid AS dbid
-    FROM ti.stewards AS stw WHERE (stw.contactid = _contactid)) AS stewardid
-    WHERE NOT (stewardid =
-
-
-  )
+    FROM ti.stewards AS stw WHERE (stw.contactid = _contactid))
   insert into ti.stewarddatabases(stewardid, databaseid)
-  values      ((select stewardid from ti.stewards AS stw where (stw.contactid IN _contactid)), _databaseid)
+  values      ((select stewardid from ti.stewards AS stw where (stw.contactid = _contactid)), _databaseid)
   RETURNING stewardid
 $function$
