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 readingIn 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 readingIn PostgreSQL, ln()
is a mathematical function that returns the natural logarithm of its argument.
In PostgreSQL, exp()
is a mathematical function that returns the exponential value of its argument.
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 readingIn 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 readingIn 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 readingIn 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 readingIn 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.
In PostgreSQL, the floor()
function is used for rounding a number down to the nearest integer.
It’s basically the opposite of ceiling()
, which rounds a number up.
It’s also similar to round()
, except that it only rounds down. The round()
function will round up or down as required.
In PostgreSQL, the round()
function is used for rounding a number.
The function can work in one of two ways, depending on how you use it. You can make it round the number to the nearest integer, or to a specified number of decimal places.
This is determined by the number of arguments you pass to the function when you call it.
Continue reading