Math Functions

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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

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

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

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

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

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

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

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

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

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)

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

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

function rand() returns double

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

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)

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

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

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

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

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

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

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

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

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

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

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

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

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

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)