Updated specimen date id in ti.insertspecimendatecal

SimonGoring · SimonGoring · commit 331127234f32 · 2020-08-07T12:32:14.000-07:00
diff --git a/function/ts/insertspecimendatecal.sql b/function/ts/insertspecimendatecal.sql
@@ -1,10 +1,10 @@
-CREATE OR REPLACE FUNCTION ts.insertspecimendatecal(_specimendatecalid integer, _calage double precision DEFAULT NULL::double precision, _calageolder double precision DEFAULT NULL::double precision, _calageyounger double precision DEFAULT NULL::double precision, _calibrationcurveid integer DEFAULT NULL::integer, _calibrationprogramid integer DEFAULT NULL::integer, _datecalibrated character varying DEFAULT NULL::character varying)
+CREATE OR REPLACE FUNCTION ts.insertspecimendatecal(_specimendateid integer, _calage double precision DEFAULT NULL::double precision, _calageolder double precision DEFAULT NULL::double precision, _calageyounger double precision DEFAULT NULL::double precision, _calibrationcurveid integer DEFAULT NULL::integer, _calibrationprogramid integer DEFAULT NULL::integer, _datecalibrated character varying DEFAULT NULL::character varying)
  RETURNS integer
  LANGUAGE sql
 AS $function$
-  INSERT INTO ndb.specimendatescal  (specimendatecalid, calage, calageolder,
+  INSERT INTO ndb.specimendatescal  (specimendateid, calage, calageolder,
     calageyounger, calibrationcurveid, calibrationprogramid, datecalibrated)
-  VALUES (_specimendatecalid, _calage, _calageolder, _calageyounger,
+  VALUES (_specimendateid, _calage, _calageolder, _calageyounger,
     _calibrationcurveid, _calibrationprogramid,
     TO_DATE(_datecalibrated, 'YYYY-MM-DD'))
   RETURNING specimendatecalid
