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()

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

Return the absolute value of the input x.

Copy

db>

SELECT math::abs(1);

{1}

Copy

db>

SELECT math::abs(-1);

{1}

function

math::ceil()

math::ceil(x: int64) -> float64math::ceil(x: float64) -> float64math::ceil(x: bigint) -> bigintmath::ceil(x: decimal) -> decimal

Round up to the nearest integer.

Copy

db>

SELECT math::ceil(1.1);

{2}

Copy

db>

SELECT math::ceil(-1.1);

{-1}

function

math::floor()

math::floor(x: int64) -> float64math::floor(x: float64) -> float64math::floor(x: bigint) -> bigintmath::floor(x: decimal) -> decimal

Round down to the nearest integer.

Copy

db>

SELECT math::floor(1.1);

{1}

Copy

db>

SELECT math::floor(-1.1);

{-2}

function

math::ln()

math::ln(x: int64) -> float64math::ln(x: float64) -> float64math::ln(x: decimal) -> decimal

Return the natural logarithm of the input value.

Copy

db>

SELECT 2.718281829 ^ math::ln(100);

{100.00000009164575}

function

math::lg()

math::lg(x: int64) -> float64math::lg(x: float64) -> float64math::lg(x: decimal) -> decimal

Return the base 10 logarithm of the input value.

Copy

db>

SELECT 10 ^ math::lg(42);

{42.00000000000001}

function

math::log()

math::log(x: decimal, NAMED ONLY base: decimal) -> decimal

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

Copy

db>

SELECT 3 ^ math::log(15n, base := 3n);

{15.0000000000000005n}

function

math::mean()

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.

Copy

db>

SELECT math::mean({1, 3, 5});

{3}

function

math::stddev()

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.

Copy

db>

SELECT math::stddev({1, 3, 5});

{2}

function

math::stddev_pop()

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.

Copy

db>

SELECT math::stddev_pop({1, 3, 5});

{1.63299316185545}

function

math::var()

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.

Copy

db>

SELECT math::var({1, 3, 5});

{4}

function

math::var_pop()

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.

Copy

db>

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

{2.66666666666667}

Functions and OperatorsBytes

Functions and OperatorsSequence

Product

Home Install Roadmap

Resources

Documentation Tutorial Easy EdgeDB Community

Company

Careers Press Kit

Newsletter

Subscribe to our mailing list to be the first to know about new blog posts and announcements.