Mathematical Functions

math::abs()

Return the absolute value of the input x.

math::ceil()

Round up to the nearest integer.

math::floor()

Round down to the nearest integer.

math::ln()

Return the natural logarithm of the input value.

math::lg()

Return the base 10 logarithm of the input value.

math::log()

Return the logarithm of the input value in the specified base.

math::mean()

Return the arithmetic mean of the input set.

math::stddev()

Return the sample standard deviation of the input set.

math::stddev_pop()

Return the population standard deviation of the input set.

math::var()

Return the sample variance of the input set.

math::var_pop()

Return the population variance of the input set.

function math::abs(x: anyreal) -> anyreal

Return the absolute value of the input x.

db> 
SELECT math::abs(1);
{1}
db> 
SELECT math::abs(-1);
{1}
function math::ceil(x: int64) -> float64math::ceil(x: float64) -> float64math::ceil(x: decimal) -> decimal

Round up to the nearest integer.

db> 
SELECT math::ceil(1.1);
{2}
db> 
SELECT math::ceil(-1.1);
{-1}
function math::floor(x: int64) -> float64math::floor(x: float64) -> float64math::floor(x: decimal) -> decimal

Round down to the nearest integer.

db> 
SELECT math::floor(1.1);
{1}
db> 
SELECT math::floor(-1.1);
{-2}
function math::ln(x: int64) -> float64math::ln(x: float64) -> float64math::ln(x: decimal) -> decimal

Return the natural logarithm of the input value.

db> 
SELECT 2.718281829 ^ math::ln(100);
{100.00000009164575}
function math::lg(x: int64) -> float64math::lg(x: float64) -> float64math::lg(x: decimal) -> decimal

Return the base 10 logarithm of the input value.

db> 
SELECT 10 ^ math::lg(42);
{42.00000000000001}
function math::log(x: decimal, NAMED ONLY base: decimal) -> decimal

Return the logarithm of the input value in the specified base.

db> 
SELECT 3 ^ math::log(15n, base := 3n);
{15.0000000000000005n}
function math::mean(vals: SET OF int64) -> float64math::mean(vals: SET OF float64) -> float64math::mean(vals: SET OF decimal) -> decimal

Return the arithmetic mean of the input set.

db> 
SELECT math::mean({1, 3, 5});
{3}
function math::stddev(vals: SET OF int64) -> float64math::stddev(vals: SET OF float64) -> float64math::stddev(vals: SET OF decimal) -> decimal

Return the sample standard deviation of the input set.

db> 
SELECT math::stddev({1, 3, 5});
{2}
function math::stddev_pop(vals: SET OF int64) -> float64math::stddev_pop(vals: SET OF float64) -> float64math::stddev_pop(vals: SET OF decimal) -> decimal

Return the population standard deviation of the input set.

db> 
SELECT math::stddev_pop({1, 3, 5});
{1.63299316185545}
function math::var(vals: SET OF int64) -> float64math::var(vals: SET OF float64) -> float64math::var(vals: SET OF decimal) -> decimal

Return the sample variance of the input set.

db> 
SELECT math::var({1, 3, 5});
{4}
function math::var_pop(vals: SET OF int64) -> float64math::var_pop(vals: SET OF float64) -> float64math::var_pop(vals: SET OF decimal) -> decimal

Return the population variance of the input set.

db> 
SELECT math::var_pop({1, 3, 5});
{2.66666666666667}