The LOG() function in SQLite calculates the logarithm of a given number to a specified base, with 10 being the default base.
This is helpful for logarithmic transformations or calculations requiring a specific base (e.g., base 10 for common logarithms or base 2 for binary logarithms).
Continue readingIn SQLite, the ceil() and ceiling() functions are used to return the smallest integer that is greater than or equal to a given number. They both serve the same purpose, and either function can be used interchangeably.
The RADIANS() function in SQLite is a mathematical function that converts an angle from degrees to radians. This can be handy when working with trigonometric calculations in your database queries, as some mathematical functions (such as SIN(), TAN()) expect angles in radians rather than degrees.
The ASIN() function in SQLite calculates the arc sine (inverse sine) of a given numeric value. The result is the angle in radians whose sine is the specified number.
The ACOS() function in SQLite is used to calculate the arc cosine (inverse cosine) of a given numeric value. The result is the angle in radians whose cosine is the specified number.
Anyone who looks at PostgreSQL’s list of mathematical functions will notice that there are some functions that have “scale” in their name. In particular, scale(), min_scale(), and trim_scale().
While these functions all have a similar name, they each have a different purpose. That said, they’re all related to the scale of the given number. The scale is the number of digits to the right of the decimal point in a number. For example, the number 1.95 has a scale of 2, and 1.958 has a scale of 3.
Continue readingIn PostgreSQL, factorial() is a mathematical function that returns the factorial of a given integer. We pass the integer (it accepts bigint), and it returns the factorial as a numeric value.
In mathematics, the factorial is the product of all positive integers less than or equal to a given positive integer. It’s denoted by that integer and an exclamation point.
Continue readingIn PostgreSQL, erfc() is a mathematical function that provides the mathematical complementary error function, without loss of precision for large inputs. It returns 1 - erf(x).
The erfc() function was introduced in PostgreSQL 16, which was released on September 14th 2023.
In PostgreSQL, erf() is a mathematical function that provides the standard mathematical error function.
The erf() function was introduced in PostgreSQL 16, which was released on September 14th 2023.
In PostgreSQL, gcd() is a mathematical function that returns the greatest common divisor. We pass two numbers and the function returns the largest positive number that divides both inputs with no remainder.