In PostgreSQL, tanh() is a hyperbolic function that returns the hyperbolic tangent of its argument.
The argument and return value are provided as a double precision value.
Continue readingTag: mathematical functions
How Sinh() Works in PostgreSQL
In PostgreSQL, sinh() is a hyperbolic function that returns the hyperbolic sine of its argument.
The argument and return value are provided as a double precision value.
Continue readingHow Mod() Works in PostgreSQL
In PostgreSQL, mod() is a mathematical function that returns the remainder from division of the first argument (the dividend) by the second argument (the divisor).
How Width_Bucket() Works in PostgreSQL
In PostgreSQL, width_bucket() is a mathematical function that assigns values to buckets (individual segments) in an equiwidth histogram.
The return type is int.
Continue readingHow Div() Works in PostgreSQL
In PostgreSQL, the div() function returns the integer quotient of its first argument divided by its second argument.
How the Power() Function Works in PostgreSQL
In PostgreSQL, the power() function returns its first argument raised to the power of its second argument.
How the Scale() Function Works in PostgreSQL
In PostgreSQL, the scale() function returns the scale of its argument.
The scale is the number of decimal digits in the fractional part.
Continue readingHow the Sign() Function Works in PostgreSQL
In PostgreSQL, the sign() function is used to indicate the sign of its argument.
It doesn’t simply return the actual sign. Rather, it returns -1 for negative numbers, 0 for zero, and 1 for positive numbers.
Continue readingHow cbrt() Works in PostgreSQL
In PostgreSQL, the cbrt() function returns the cube root of its argument.
The cube root of a number x is a number y such that y3 = x.
Continue readingHow sqrt() Works in PostgreSQL
In PostgreSQL, the sqrt() function returns the square root of its argument.
The square root of a number x is the number y such that y2 = x.
Continue reading