ποΈ abs
Returns the absolute value of the numeric value x. If the input value is NULL, NULL is returned.
ποΈ acos
Computes the arc cosine of an argument.
ποΈ asin
Computes the arc sine of the argument.
ποΈ atan
Computes the arc tangent of the argument.
ποΈ atan2
Returns the arc tangent of x divided by y, that is, the arc tangent of x/y. The signs of the two parameters are used to determine the quadrant of the result.
ποΈ bin
Transforms the input arg into a binary.
ποΈ cbrt
Computes the cube root of the argument.
ποΈ ceil, dceil
Returns values from the input arg rounded to the nearest equal or larger integer.
ποΈ ceiling
Returns values from the input arg rounded to the nearest equal or larger integer.
ποΈ conv
Converts the number x from one numeric base system to another, and returns the result as a string value.
ποΈ cos
Computes the cosine of the argument.
ποΈ cos_similarity
Measures the similarity of two vectors by calculating the cosine of the angle between them. The angle is formed by the direction of the vectors while the difference in their magnitude is ignored.
ποΈ cos_similarity_norm
Measures the similarity of two normalized vectors by calculating the cosine of the angle between them. The angle is formed by the direction of the vectors while the difference in their magnitude is ignored. This function assumes that the input vectors have been normalized. If you need to normalize vectors before calculating the cosine similarity, use cosinesimilarity.
ποΈ cosh
Computes the hyperbolic cosine of the argument.
ποΈ cot
Returns the cotangent of the angle in radians x. If the angle in radians x is 0 or NULL, NULL is returned.
ποΈ degrees
Converts the angle in radians x to degrees.
ποΈ divide
Return the quotient of x divide y. If y is 0, return null.
ποΈ e
Returns the constant e (the base of natural logarithms).
ποΈ exp,dexp
Returns the value of e raised to the power of x. This function is called natural logarithms function.
ποΈ floor, dfloor
Returns the largest integer that is not more than x.
ποΈ fmod
Returns the floating point remainder of the division ( dividend/divisor ). It is a modulo function.
ποΈ greatest
Returns the largest value from a list of one or more parameters.
ποΈ least
Returns the smallest value from a list of one or more parameters.
ποΈ ln, dlog1, log
Computes the natural (base e) logarithm of a number.
ποΈ log
Calculates the logarithm of a number to a specified base (or radix). If the base is not specified, this function is equivalent to ln.
ποΈ log10, dlog10
Calculates the base 10 logarithm of a number.
ποΈ log2
Calculates the base 2 logarithm of a number.
ποΈ mod
The modulus function that returns the remainder of dividend divided by divisor.
ποΈ multiply
Computes the product of the arguments.
ποΈ negative
Returns the negative of input arg.
ποΈ pi
Returns the value of Pi.
ποΈ pmod
Returns the positive remainder of dividend divided bydivisor.
ποΈ positive
Returns x as a value.
π οΈ pow, power, dpow, fpow
Returns the result of x raised to the power of y.
ποΈ radians
Converts x from an angle to a radian.
ποΈ rand, random
Returns a random floating-point number between 0 (inclusive) and 1 (exclusive).
ποΈ round, dround
Rounds a number to a specified number of digits.
ποΈ sign
Returns the sign of x. A negative number, 0, or a positive number as input corresponds to -1, 0, or 1 as output, respectively.
ποΈ sin
Returns the sine of x, where x is in radians.
ποΈ sinh
Computes the hyperbolic sine of the argument.
ποΈ sqrt, dsqrt
Calculates the square root of a value. dsqrt is same as sqrt.
ποΈ square
Calculates the square of a value.
ποΈ tan
Returns the tangent of x, where x is in radians.
ποΈ tanh
Computes the hyperbolic tangent of the argument.
ποΈ truncate
Rounds the input down to the nearest equal or smaller value with the specified number of places after the decimal point.