Uses of Class
dev.frostlake.functions.NumericArgumentFunction

Packages that use NumericArgumentFunction
  • Uses of NumericArgumentFunction in dev.frostlake.functions.scalar.conditional

    Modifier and Type
    Class
    Description
    class 
    ZEROIFNULL 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

    Modifier and Type
    Class
    Description
    class 
    ABS(n) — the absolute value of the numeric input, computed exactly over BigDecimal so a fixed-point argument keeps its scale.
    class 
    ACOS(x) — inverse cosine in radians.
    class 
    ACOSH(x) — inverse hyperbolic cosine, computed as ln(x + sqrt(x*x - 1)) since Math has no acosh.
    class 
     
    class 
    ASINH(x) — inverse hyperbolic sine, computed as ln(x + sqrt(x*x + 1)) since Math has no asinh.
    class 
     
    class 
     
    class 
    ATANH(x) — inverse hyperbolic tangent, computed as 0.5 * ln((1 + x) / (1 - x)) since Math has no atanh.
    class 
     
    class 
     
    class 
     
    class 
     
    class 
     
    class 
     
    class 
     
    class 
    CEIL(n [, scale]) — the input rounded UP, to whole numbers by default and to scale decimal places when one is given.
    class 
     
    class 
     
    class 
     
    class 
     
    class 
    DIV0(a, b) divides like the / operator but returns 0 when the divisor is 0.
    class 
     
    class 
     
    class 
    FLOOR(n [, scale]) — the input rounded DOWN, to whole numbers by default and to scale decimal places when one is given.
    class 
    GETBIT(integer_expr, bit_position) — the value (0 or 1) of the bit at the 0-based bit_position, counting from the least significant bit.
    class 
     
    class 
     
    class 
     
    class 
     
    class 
     
    class 
     
    class 
    ROUND(n [, scale [, mode]]) — the input rounded to scale decimal places, zero by default.
    class 
     
    class 
     
    class 
     
    class 
     
    class 
     
    class 
     
    class 
     
    class 
     
    class 
    UNIFORM(min, max [, gen]) — a uniformly random value in the range.
    class 
    WIDTH_BUCKET(value, min, max, count) — which of count equal buckets between min and max the value falls in, 0 below the range and count + 1 above it.