ASIN¶

The ASIN function is used to calculate the arcsine (inverse sine) of a number. It takes a single numeric argument, which should be a float value in the range of -1 to 1, and returns the arcsine of that number in radians.

Syntax¶

ASIN(value)

• value: A numeric expression for which the arcsine is to be calculated. The value should be in the range of -1 to 1.

Examples¶

Let's consider a table named SingleItem with the following schema:

CREATE TABLE SingleItem (id INTEGER);

Insert a row into the SingleItem table:

INSERT INTO SingleItem VALUES (0);

Example 1: Using ASIN with float values¶

SELECT ASIN(0.5) AS asin1, ASIN(1) AS asin2 FROM SingleItem;

Result:

     asin1      |     asin2
----------------+---------------
 0.5235987755983 | 1.5707963267949

Example 2: Using ASIN with NULL values¶

SELECT ASIN(NULL) AS asin FROM SingleItem;

Result:

  asin
-------
 (null)

Errors¶

The ASIN function requires a numeric value in the range of -1 to 1 as its argument. Using non-numeric values or more than one argument will result in an error.

Example 3: Using ASIN with non-numeric values¶

SELECT ASIN('string') AS asin FROM SingleItem;

Error: Function requires a numeric value.

Example 4: Using ASIN with multiple arguments¶

SELECT ASIN(1.0, 2.0) AS sin FROM SingleItem;

Error: Function expects 1 argument, but 2 were provided.