func.abs
Returns the absolute value of a number. The absolute value of a number is the number without its sign
Math
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 December 20, 2022 at 10:05 AM EST: remove sitemap priority (56709da)