Math Functions and Operators

abs(number int|float)

Returns absolute value

Parameters:number – input number
Return type:same as a parameter type
Example: 
select abs(-9);
> 9
acos(number float)

Returns the arc cosine of number value

Parameters:number – input number as radian
Return type:float8
Example: 
select acos(0.3);
> 1.2661036727794992
asin(number float)

Returns the arc sine of number value

Parameters:number – input number as radian
Return type:float8
Example: 
select acos(0.8);
> 0.9272952180016123
atan(number float8)

Returns the arc tangent of number value

Parameters:number – input number as radian
Return type:float8
Example: 
select atan(0.8);
> 0.6747409422235527
atan2(y float, x float)

Returns the angle theta from the conversion of rectangular coordinates (x, y) to polar coordinates (r, theta)

Parameters:
  • y – the ordinate(y axis) coordinate
  • x – the abscissa(x axis) coordinate
Return type:

float8
Example: 
select atan2(2.7, 0.3);
> 1.460139105621001
cbrt(number float)

Returns the cube root of a number

Parameters:number – target real number
Return type:float8
Example: 
select cbrt(27.0);
> 3.0
ceil(number float)

Returns a smallest integer not less than argument

Parameters:number – target real number
Return type:int8
Alias:ceiling
Example: 
select ceil(-42.8);
> -42
cos(number float)

Returns the cosine of a number

Parameters:number – target real number
Return type:float8
Example: 
select cos(0.7);
> 0.7648421872844885
degrees(number float)

Converts radians to degrees

Parameters:number – radian value
Return type:float8
Example: 
select degrees(0.8);
> 45.83662361046586
div(num1 int, num2 int)

Integer division truncates resut

Parameters:
  • num1 – number to be divided
  • num2 – number to divide
Return type:

int8
Example: 
select div(8,3);
> 2
exp(number float)

Returns Euler’s number e raised to the power of a number

Parameters:number – input number
Return type:float8
Example: 
select exp(1.0);
> 2.718281828459045
floor(number float)

Returns a largest integer not greater than argument

Parameters:number – target real number
Return type:int8
Example: 
select floor(53.1);
> 53
mod(num1 int, num2 int)

Returns remainder of num1 / num2

Parameters:
  • num1 – number to be divided
  • num2 – number to divide
Return type:

int8
Example: 
select mod(10,3);
> 1
pi()

Returns constant value of pi

Return type:float8
Example: 
select pi();
> 3.141592653589793
pow(x float, y float)

Returns value of x raised to the power of y

Parameters:
  • x – base number
  • y – exponent
Return type:

float8
Example: 
select pow(2.0, 10.0);
> 1024.0
radians(number float)

Converts degrees to radians

Parameters:number – degree value
Return type:float8
Example: 
select radians(45.0);
> 0.7853981633974483
random(number int4)

Returns a pseudorandom number.

Parameters:number – range restriction
Return type:int4
Example: 
select random(10);
> 4
round(number int|float)

Rounds to nearest integer

Parameters:number – target number
Return type:int8
Example: 
select round(5.1);
> 5
sign(number int|float)

Returns sign of argument as -1, 0, 1

Parameters:number – target number
Return type:float8
Example: 
select sign(-8.4);
> -1.0
sin(number float)

Returns the sine of number value

Parameters:number – target number
Return type:float8
Example: 
select sin(1.0);
> 0.8414709848078965
sqrt(number float8)

Returns the square root of a number

Parameters:number – target number
Return type:float8
Example: 
select sqrt(256.0);
> 16.0
tan(number float)

Returns the tangent of number value

Parameters:number – target number
Return type:float8
Example: 
select tan(0.2);
> 0.2027100355086725