Uses of Class
dev.frostlake.functions.NumericArgumentFunction
Packages that use NumericArgumentFunction
-
Uses of NumericArgumentFunction in dev.frostlake.functions.scalar.conditional
Subclasses of NumericArgumentFunction in dev.frostlake.functions.scalar.conditionalModifier and TypeClassDescriptionclassZEROIFNULL refuses more DECLARED families than its numeric-argument neighbours: a SQL BOOLEAN, every temporal flavour and a BINARY are each a compile-time argument-type error — positioned at the call, the family named with its parameters ((BOOLEAN), (DATE), (TIME(9)), (TIMESTAMP_NTZ(9)), (BINARY(67108864))) — while NUMBER, FLOAT, VARCHAR and VARIANT convert, a VARIANT even when it holds the same boolean that is refused declared (all live-verified). -
Uses of NumericArgumentFunction in dev.frostlake.functions.scalar.math
Subclasses of NumericArgumentFunction in dev.frostlake.functions.scalar.mathModifier and TypeClassDescriptionclassABS(n) — the absolute value of the numeric input, computed exactly overBigDecimalso a fixed-point argument keeps its scale.classACOS(x) — inverse cosine in radians.classclassclassclassclassclassATANH(x) — inverse hyperbolic tangent, computed as0.5 * ln((1 + x) / (1 - x))sinceMathhas noatanh.classclassclassclassclassclassclassclassCEIL(n [, scale]) — the input rounded UP, to whole numbers by default and toscaledecimal places when one is given.classclassclassclassclassDIV0(a, b) divides like the/operator but returns 0 when the divisor is 0.classclassclassFLOOR(n [, scale]) — the input rounded DOWN, to whole numbers by default and toscaledecimal places when one is given.classGETBIT(integer_expr, bit_position) — the value (0 or 1) of the bit at the 0-basedbit_position, counting from the least significant bit.classclassclassclassclassclassclassROUND(n [, scale [, mode]]) — the input rounded toscaledecimal places, zero by default.classclassclassclassclassclassclassclassclassUNIFORM(min, max [, gen]) — a uniformly random value in the range.classWIDTH_BUCKET(value, min, max, count) — which ofcountequal buckets betweenminandmaxthe value falls in, 0 below the range andcount + 1above it.