PostgreSQL asind() Function

The PostgreSQL asind() function returns the arc sine of the specified number in degrees.

asind() Syntax

This is the syntax of the PostgreSQL asind() function:

asind(number)

asind(number) is equivalent to degrees(asin(number)).

Parameters

number

Required. The number used to calculate the arcsine. It should be between -1 and 1, inclusive.

Return value

The PostgreSQL asind() function returns the arc sine of the specified number in degrees.

If the argument number is not between -1 and 1, the asind() function will throw an error.

If the parameter number is NULL, the asind() function will return NULL.

asind() Examples

Here are a few examples of the asind() function:

SELECT
    asind(-1) AS "asind(-1)",
    asind(-0.5) AS "asind(-0.5)",
    asind(-0.2) AS "asind(-0.2)",
    asind(0) AS "asind(0)",
    asind(0.2) AS "asind(0.2)",
    asind(0.5) AS "asind(0.5)",
    asind(1) AS "asind(1)";

-[ RECORD 1 ]--------------------
asind(-1)   | -90
asind(-0.5) | -30
asind(-0.2) | -11.536959032815487
asind(0)    | 0
asind(0.2)  | 11.536959032815487
asind(0.5)  | 30
asind(1)    | 90

asind(number) is equivalent to converting the result of asin(number) to degrees using the degrees() function, for example:

SELECT
    asind(1) AS "asind(1)",
    degrees(asin(1)) AS "degrees(asin(1))";

-[ RECORD 1 ]----+---
asind(1)         | 90
degrees(asin(1)) | 90