Math Functions

abs

Supported Signatures

function abs $1($1) returns $1
	where $1 in (bigint, float64)

🔗 Official Documentation

acos

Supported Signatures

function acos $1($1) returns double
	where $1 in (double, bigint)

🔗 Official Documentation

acosh

Supported Signatures

function acosh $1($1) returns double
	where $1 in (double, bigint)

🔗 Official Documentation

asin

Supported Signatures

function asin $1($1) returns double
	where $1 in (double, bigint)

🔗 Official Documentation

asinh

Supported Signatures

function asinh $1($1) returns double
	where $1 in (double, bigint)

🔗 Official Documentation

atan

Supported Signatures

function atan $1($1) returns double
	where $1 in (double, bigint)

🔗 Official Documentation

atan2

Supported Signatures

function atan2 $1, $2($1, $2) returns double
	where $1 in (bigint, double)
	and $2 in (bigint, double)

🔗 Official Documentation

atanh

Supported Signatures

function atanh $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

cbrt

Supported Signatures

function cbrt $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

ceil

Supported Signatures

function ceil(bigint) returns double
function ceil $1($1) returns $1
	where $1 in (double)

🔗 Official Documentation

ceiling

Supported Signatures

function ceiling(bigint) returns double
function ceiling $1($1) returns $1
	where $1 in (double)

🔗 Official Documentation

cos

Supported Signatures

function cos $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

cosh

Supported Signatures

function cosh $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

cot

Supported Signatures

function cot $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

coth

Supported Signatures

function coth $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

csc

Supported Signatures

function csc $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

csch

Supported Signatures

function csch $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

div

Supported Signatures

function div $1($1, $1) returns $1
	where $1 in (bigint)
function div(bigint, decimal(p,s)) returns decimal(p,s)
function div(decimal(p,s), bigint) returns decimal(p,s)
function div(decimal(p,s), bigint) returns decimal(p,s)
function div(bigint, decimal(p,s)) returns decimal(p,s)

🔗 Official Documentation

exp

Supported Signatures

function exp(bigint) returns double
function exp $1($1) returns $1
	where $1 in (double)

🔗 Official Documentation

floor

Supported Signatures

function floor $1($1) returns $1
	where $1 in (double)
function floor(bigint) returns double

🔗 Official Documentation

greatest

Supported Signatures

function greatest $1($1, ...) returns $1
	where $1 in (bigint, double, timestamp, date, time)

🔗 Official Documentation

ieee_divide

Supported Signatures

function ieee_divide $1, $2($1, $2) returns double
	where $1 in (bigint, double)
	and $2 in (bigint, double)

🔗 Official Documentation

is_inf

Supported Signatures

function is_inf $1($1) returns bool
	where $1 in (bigint, double)

🔗 Official Documentation

is_nan

Supported Signatures

function is_nan $1($1) returns bool
	where $1 in (bigint, double)

🔗 Official Documentation

least

Supported Signatures

function least $1($1, ...) returns $1
	where $1 in (bigint, double, timestamp, date, time)

🔗 Official Documentation

ln

Supported Signatures

function ln(bigint) returns double
function ln $1($1) returns double
	where $1 in (double)

🔗 Official Documentation

log

Supported Signatures

function log(bigint) returns double
function log $1($1) returns double
	where $1 in (double)
function log $1($1, $1) returns $1
	where $1 in (double)
function log(bigint, bigint) returns double
function log(bigint, decimal(p,s)) returns decimal(p,s)
function log(decimal(p,s), bigint) returns decimal(p,s)
function log(decimal(p,s), bigint) returns decimal(p,s)
function log(bigint, decimal(p,s)) returns decimal(p,s)
function log(double, bigint) returns double
function log(bigint, double) returns double
function log(decimal(p,s), double) returns double
function log(double, decimal(p,s)) returns double
function log(double, decimal(p,s)) returns double
function log(decimal(p,s), double) returns double

🔗 Official Documentation

log10

Supported Signatures

function log10(bigint) returns double
function log10 $1($1) returns $1
	where $1 in (double)

🔗 Official Documentation

mod

Supported Signatures

function mod $1($1, $1) returns $1
	where $1 in (bigint)
function mod(bigint, decimal(p,s)) returns decimal(p,s)
function mod(decimal(p,s), bigint) returns decimal(p,s)
function mod(decimal(p,s), bigint) returns decimal(p,s)
function mod(bigint, decimal(p,s)) returns decimal(p,s)

🔗 Official Documentation

pow

Supported Signatures

function pow $1($1, $1) returns $1
	where $1 in (double)
function pow(bigint, bigint) returns double
function pow(bigint, decimal(p,s)) returns decimal(p,s)
function pow(decimal(p,s), bigint) returns decimal(p,s)
function pow(decimal(p,s), bigint) returns decimal(p,s)
function pow(bigint, decimal(p,s)) returns decimal(p,s)
function pow(double, bigint) returns double
function pow(bigint, double) returns double
function pow(double, decimal(p,s)) returns double
function pow(decimal(p,s), double) returns double
function pow(double, decimal(p,s)) returns double
function pow(decimal(p,s), double) returns double

🔗 Official Documentation

power

Supported Signatures

function power $1($1, $1) returns $1
	where $1 in (double)
function power(bigint, bigint) returns double
function power(bigint, decimal(p,s)) returns decimal(p,s)
function power(decimal(p,s), bigint) returns decimal(p,s)
function power(decimal(p,s), bigint) returns decimal(p,s)
function power(bigint, decimal(p,s)) returns decimal(p,s)
function power(double, bigint) returns double
function power(bigint, double) returns double
function power(double, decimal(p,s)) returns double
function power(decimal(p,s), double) returns double
function power(double, decimal(p,s)) returns double
function power(decimal(p,s), double) returns double

🔗 Official Documentation

rand

Supported Signatures

function rand() returns double

🔗 Official Documentation

range_bucket

Supported Signatures

function range_bucket($1, array<$1>) returns int64

🔗 Official Documentation

round

Supported Signatures

function round(bigint) returns double
function round $1($1) returns $1
	where $1 in (double)
function round(bigint, bigint) returns double
function round $1($1, bigint) returns $1
	where $1 in (double)
function round(bigint, bigint, rounding_mode string) returns double
	where rounding_mode in (round_half_even, round_half_away_from_zero)
function round $1($1, bigint, rounding_mode string) returns $1
	where rounding_mode in (round_half_even, round_half_away_from_zero)
	where $1 in (double)

🔗 Official Documentation

safe_add

Supported Signatures

function safe_add $1($1, $1) returns $1
	where $1 in (bigint, double)
function safe_add(bigint, decimal(p,s)) returns decimal(p,s)
function safe_add(decimal(p,s), bigint) returns decimal(p,s)
function safe_add(decimal(p,s), bigint) returns decimal(p,s)
function safe_add(bigint, decimal(p,s)) returns decimal(p,s)
function safe_add(double, bigint) returns double
function safe_add(bigint, double) returns double
function safe_add(double, decimal(p,s)) returns double
function safe_add(decimal(p,s), double) returns double
function safe_add(double, decimal(p,s)) returns double
function safe_add(decimal(p,s), double) returns double

🔗 Official Documentation

safe_divide

Supported Signatures

function safe_divide $1($1, $1) returns double
	where $1 in (bigint, double)
function safe_divide(bigint, decimal(p,s)) returns decimal(p,s)
function safe_divide(decimal(p,s), bigint) returns decimal(p,s)
function safe_divide(decimal(p,s), bigint) returns decimal(p,s)
function safe_divide(bigint, decimal(p,s)) returns decimal(p,s)
function safe_divide(double, bigint) returns double
function safe_divide(bigint, double) returns double
function safe_divide(double, decimal(p,s)) returns double
function safe_divide(decimal(p,s), double) returns double
function safe_divide(double, decimal(p,s)) returns double
function safe_divide(decimal(p,s), double) returns double

🔗 Official Documentation

safe_multiply

Supported Signatures

function safe_multiply $1($1, $1) returns $1
	where $1 in (bigint, double)
function safe_multiply(bigint, decimal(p,s)) returns decimal(p,s)
function safe_multiply(decimal(p,s), bigint) returns decimal(p,s)
function safe_multiply(decimal(p,s), bigint) returns decimal(p,s)
function safe_multiply(bigint, decimal(p,s)) returns decimal(p,s)
function safe_multiply(double, bigint) returns double
function safe_multiply(bigint, double) returns double
function safe_multiply(double, decimal(p,s)) returns double
function safe_multiply(decimal(p,s), double) returns double
function safe_multiply(double, decimal(p,s)) returns double
function safe_multiply(decimal(p,s), double) returns double

🔗 Official Documentation

safe_negate

Supported Signatures

function safe_negate $1($1) returns $1
	where $1 in (bigint, double)

🔗 Official Documentation

safe_subtract

Supported Signatures

function safe_subtract $1($1, $1) returns $1
	where $1 in (bigint, double)
function safe_subtract(bigint, decimal(p,s)) returns decimal(p,s)
function safe_subtract(decimal(p,s), bigint) returns decimal(p,s)
function safe_subtract(decimal(p,s), bigint) returns decimal(p,s)
function safe_subtract(bigint, decimal(p,s)) returns decimal(p,s)
function safe_subtract(double, bigint) returns double
function safe_subtract(bigint, double) returns double
function safe_subtract(double, decimal(p,s)) returns double
function safe_subtract(decimal(p,s), double) returns double
function safe_subtract(double, decimal(p,s)) returns double
function safe_subtract(decimal(p,s), double) returns double

🔗 Official Documentation

sec

Supported Signatures

function sec $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

sech

Supported Signatures

function sech $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

sign

Supported Signatures

function sign $1($1) returns $1
	where $1 in (bigint, double)

🔗 Official Documentation

sin

Supported Signatures

function sin $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

sinh

Supported Signatures

function sinh $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

sqrt

Supported Signatures

function sqrt(bigint) returns double
function sqrt $1($1) returns $1
	where $1 in (double)

🔗 Official Documentation

tan

Supported Signatures

function tan $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

tanh

Supported Signatures

function tanh $1($1) returns double
	where $1 in (bigint, double)

🔗 Official Documentation

trunc

Supported Signatures

function trunc(bigint) returns double
function trunc $1($1) returns $1
	where $1 in (double)
function trunc(bigint, bigint) returns double
function trunc $1($1, bigint) returns $1
	where $1 in (double)

🔗 Official Documentation