PostgreSQL LOG10() Function
The PostgreSQL LOG10() function returns the base-10 logarithm of a given number. If the argument is less than or equal to 0, an error is returned.
Syntax
LOG10(number)
Parameters
number |
Required. Specify the number. Must be greater than 0. |
Return Value
Returns the base-10 logarithm of a given number.
Example 1:
The example below shows the usage of LOG10() function.
SELECT LOG10(1); Result: 0 SELECT LOG10(2); Result: 0.3010299956639812 SELECT LOG10(3); Result: 0.47712125471966244 SELECT LOG10(10); Result: 1 SELECT LOG10(15); Result: 1.1760912590556813
Example 2:
Consider a database table called Sample with the following records:
Data | x |
---|---|
Data 1 | 0.5 |
Data 2 | 1 |
Data 3 | 5 |
Data 4 | 10 |
Data 5 | 50 |
The statement given below can be used to calculate the base-10 logarithm of column x.
SELECT *, LOG10(x) AS LOG10_Value FROM Sample;
This will produce the result as shown below:
Data | x | LOG10_Value |
---|---|---|
Data 1 | 0.5 | -0.3010299956639812 |
Data 2 | 1 | 0 |
Data 3 | 5 | 0.6989700043360189 |
Data 4 | 10 | 1 |
Data 5 | 50 | 1.6989700043360187 |
❮ PostgreSQL Functions