Adding function that seems to be throwing errors. ts.updatechroncontroldepththickness() now exists.

SimonGoring · SimonGoring · commit 9c564745b227 · 2021-04-20T15:51:46.000-07:00
diff --git a/function/ts/updatechroncontroldepththickness.sql b/function/ts/updatechroncontroldepththickness.sql
@@ -0,0 +1,8 @@
+CREATE OR REPLACE FUNCTION ts.updatechroncontrolanalysisunit(_chroncontrolid integer, _depth integer, _thickness integer, _analunitid integer)
+ RETURNS void
+ LANGUAGE sql
+AS $function$
+	UPDATE ndb.chroncontrols AS cc
+	SET   depth = _depth, thickness = _thickness
+	WHERE cc.chroncontrolid = _chroncontrolid AND analysisunitid = _analunitid;
+$function$
