PostgreSQL ATANH() Function

The PostgreSQL ATANH() function returns inverse hyperbolic tangent of a value. The inverse hyperbolic tangent of x is defined as:

If the argument is not in range [-1, 1], then this function returns an error.

Syntax

ATANH(x)

Parameters

Return Value

Returns the inverse hyperbolic tangent of the value.

Example 1:

The example below shows the usage of ATANH() function.

SELECT ATANH(-1);
Result: -Infinity

SELECT ATANH(-0.5);
Result: -0.5493061443340548

SELECT ATANH(0);
Result: 0

SELECT ATANH(0.5);
Result: 0.5493061443340548

SELECT ATANH(1);
Result: Infinity

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to calculate the inverse hyperbolic tangent of records of column x.

SELECT *, ATANH(x) AS ATANH_Value FROM Sample;

This will produce the result as shown below: