In PostgreSQL, acos() is a mathematical function that returns the inverse cosine of the specified expression, measured in radians.
The inverse cosine is also known as the arccosine.
Continue readingTag: mathematical functions
How Acosd() Works in PostgreSQL
In PostgreSQL, acosd() is a mathematical function that returns the inverse cosine of the specified expression, measured in degrees.
The inverse cosine is also known as the arccosine.
Continue readingHow Log() Works in PostgreSQL
In PostgreSQL, log() is a mathematical function that returns the base 10 logarithm of its argument.
However, it also allows you to optionally specify a base with which to use.
Continue readingHow the Ln() Function Works in PostgreSQL
In PostgreSQL, ln() is a mathematical function that returns the natural logarithm of its argument.
How the Exp() Function Works in PostgreSQL
In PostgreSQL, exp() is a mathematical function that returns the exponential value of its argument.
How Pi() Works in PostgreSQL
In PostgreSQL, the pi() function returns the number π.
Ï€ constant is a mathematical constant. It is defined as the ratio of a circle’s circumference to its diameter.
Continue readingHow the Degrees() Function Works in PostgreSQL
In PostgreSQL, the degrees() function converts from radians to degrees.
The radian is the SI (International System of Units) unit for measuring angles. One radian is just under 57.3 degrees, and a full circle has just over 6.28 radians (2Ï€).
Continue readingHow the Radians() Function Works in PostgreSQL
In PostgreSQL, the radians() function converts from degrees to radians.
The radian is the SI (International System of Units) unit for measuring angles. One radian is just under 57.3 degrees, and a full circle has just over 6.28 radians (2Ï€).
Continue readingHow Trunc() Works in PostgreSQL
In PostgreSQL, the trunc() function truncates a number.
More specifically, it truncates the number either toward zero, or to a specific number of decimal places.
Continue readingHow Ceiling() Works in PostgreSQL
In PostgreSQL, the ceiling() function is used for rounding a number up to the nearest integer.
It’s similar to round(), except that it only rounds up. The round() function will round up or down as required.
It’s also similar to floor(), except that floor() rounds down instead of up.