Math


func.abs

Returns the absolute value of a number. The absolute value of a number is the number without its sign

func.cbrt

This function accepts a number as argument and returns the cube root of that number

func.ceil

The ceil() function is used to return the value, after rounded up any positive or negative decimal value as greater than the argument

func.ceiling

The PostgreSQL ceiling() is used to return the value after rounded up any positive or negative decimal value as greater than the argument

func.degrees

The PostgreSQL degrees() function is used to return the values in degrees from radian as specified in the argument.

func.exp

The PostgreSQL exp function returns 'e' raised to the power of 'number'

func.floor

The PostgreSQL FLOOR() function returns a number rounded down to the next whole number

func.greatest

he GREATEST function returns the “greatest” or “largest” value from the list of expressions

func.least

The LEAST function returns the “least” or “smallest” value from the list of expressions

func.ln

The PostgreSQL ln() function is used to return the natural logarithm of a given number, as specified in the argument.

func.log

The log() function returns the base 10 logarithm of a given number or logarithm of a number for a particular base, specific to the argument

func.mod

The MOD() function performs the modulo operation that returns the remainder after the division of the first argument by the second one

func.pi

The PostgreSQL pi() function is used to return the constant value of pi

func.power

The PostgreSQL power() function is used to return the value of one number raised to the power of another number, provided in the argument

func.radians

The PostgreSQL radians() function is used to return the value in radian from degrees, provided in the argument

func.random

The PostgreSQL random() function is used to return the random value between 0 and 1.

func.round

The PostgreSQL ROUND() function rounds a numeric value to its nearest integer or a number with the number of decimal places

func.safe_divide

Equivalent to the division operator (X / Y), but returns NULL if an error occurs, such as a division by zero error

func.setseed

The PostgreSQL setseed function can be used to set a seed for the next time that you call the random function

func.sign

The PostgreSQL sign function returns a value indicating the sign of a number.

func.sqrt

The PostgreSQL sqrt() function is used to return the square root of a given positive number.

func.trunc

The PostgreSQL TRUNC() function returns a number truncated to a whole number or truncated to the specified decimal places

func.width_bucket

In PostgreSQL, width_bucket() is a mathematical function that assigns values to buckets (individual segments) in an equiwidth histogram.

Last modified April 06, 2022 at 10:08 AM EST: Initial Documentation Commit (371ae8f)