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.
DBMS
Database Management Systems
How 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 to Create Ordinal Numbers in PostgreSQL
In PostgreSQL, you can use the to_char() function to output numbers in a given format. This includes appending the number with the ordinal indicator.
For example 1, 2, 3 becomes 1st, 2nd, 3rd.
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.
How 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π).
How 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π).
How 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.
Add the Ordinal Indicator to a Date in PostgreSQL
The PostgreSQL to_char() function provides us with the option of adding the ordinal number suffix to the result.
This means we can add the ordinal indicator when formatting dates.
For example, instead of outputting 10 Feb we could output 10th Feb.