update chron control age basis.

SimonGoring · SimonGoring · commit 8d813f285378 · 2020-10-23T16:05:50.000-07:00
Direct translation.
diff --git a/function/ts/updatechroncontrolagebasis.sql b/function/ts/updatechroncontrolagebasis.sql
@@ -0,0 +1,8 @@
+CREATE OR REPLACE FUNCTION ts.updatechroncontrolagebasis(_chroncontrolid integer, _chroncontroltypeid integer)
+ RETURNS void
+ LANGUAGE sql
+AS $function$
+  UPDATE ndb.chroncontrols
+  SET chroncontroltypeid = _chroncontroltypeid
+  WHERE chroncontrolid = _chroncontrolid
+$function$
