Math
List of functions
Math::E() -> Double
Math::Eps() -> Double
Examples
(Double) -> Bool
List of functions
Math::IsInf(Double{Flags:AutoMap}) -> Bool
Math::IsNaN(Double{Flags:AutoMap}) -> Bool
Math::IsFinite(Double{Flags:AutoMap}) -> Bool
Examples
SELECT Math::IsNaN(0.0/0.0); -- true
Math::Abs(Double{Flags:AutoMap}) -> Double
Math::Acos(Double{Flags:AutoMap}) -> Double
Math::Asin(Double{Flags:AutoMap}) -> Double
Math::Asinh(Double{Flags:AutoMap}) -> Double
Math::Atan(Double{Flags:AutoMap}) -> Double
Math::Cbrt(Double{Flags:AutoMap}) -> Double
Math::Ceil(Double{Flags:AutoMap}) -> Double
Math::Cos(Double{Flags:AutoMap}) -> Double
Math::Erf(Double{Flags:AutoMap}) -> Double
Math::ErfInv(Double{Flags:AutoMap}) -> Double
Math::ErfcInv(Double{Flags:AutoMap}) -> Double
Math::Exp(Double{Flags:AutoMap}) -> Double
Math::Exp2(Double{Flags:AutoMap}) -> Double
Math::Fabs(Double{Flags:AutoMap}) -> Double
Math::Floor(Double{Flags:AutoMap}) -> Double
Math::Lgamma(Double{Flags:AutoMap}) -> Double
Math::Rint(Double{Flags:AutoMap}) -> Double
Math::Sigmoid(Double{Flags:AutoMap}) -> Double
Math::Sin(Double{Flags:AutoMap}) -> Double
Math::Sinh(Double{Flags:AutoMap}) -> Double
Math::Tan(Double{Flags:AutoMap}) -> Double
Math::Tanh(Double{Flags:AutoMap}) -> Double
Math::Trunc(Double{Flags:AutoMap}) -> Double
Math::Log(Double{Flags:AutoMap}) -> Double
Math::Log2(Double{Flags:AutoMap}) -> Double
Math::Log10(Double{Flags:AutoMap}) -> Double
Examples
(Double, Double) -> Double
List of functions
Math::Atan2(Double{Flags:AutoMap}, Double{Flags:AutoMap}) -> Double
Math::Fmod(Double{Flags:AutoMap}, Double{Flags:AutoMap}) -> Double
Math::Hypot(Double{Flags:AutoMap}, Double{Flags:AutoMap}) -> Double
Math::Pow(Double{Flags:AutoMap}, Double{Flags:AutoMap}) -> Double
Math::Remainder(Double{Flags:AutoMap}, Double{Flags:AutoMap}) -> Double
Examples
SELECT Math::Atan2(1, 0); -- 1.570796327
SELECT Math::Remainder(2.1, 2); -- 0.1
List of functions
Math::Ldexp(Double{Flags:AutoMap}, Int32{Flags:AutoMap}) -> Double
Math::Round(Double{Flags:AutoMap}, [Int32?]) -> Double
: The second argument indicates the power of 10 to which we round (it’s negative for decimal digits and positive for rounding to tens, thousands, or millions); the default value is 0
(Double, Double, [Double?]) -> Bool
List of functions
Math::FuzzyEquals(Double{Flags:AutoMap}, Double{Flags:AutoMap}, [Double?]) -> Bool
: Compares two Doubles for being inside the neighborhood specified by the third argument; the default value is 1.0e-13
Examples
SELECT Math::FuzzyEquals(1.01, 1.0, 0.05); -- true
List of functions
Math::Rem(Int64{Flags:AutoMap}, Int64) -> Int64?
These functions behave similarly to the built-in % operator in the case of non-negative arguments. The differences are noticeable in the case of negative arguments:
- Math::Mod preserves the sign of the second argument (the denominator).