Skip to main content

​
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