pears.TempRatePrecision

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."TempRatePrecision" IS 
{CREATE FUNCTION TempRatePrecision 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN TempUnits NUMERIC)
RETURNS NUMERIC
BEGIN
  DECLARE rv NUMERIC;
  SELECT IF isnull(TmpRatePrecision,0)=2 THEN iqmoneyround(TempUnits)  ELSE round(TempUnits, TmpRatePrecision) END IF INTO rv;
  RETURN rv;
END
}