ASIN
Returns the inverse sine value of a numeric expression
Syntax
ASIN( expr )
Arguments
Parameter |
Description |
---|---|
|
Numeric expression in range |
Returns
Always returns a floating point result of the inverse sine, in radians.
Notes
Valid inputs for an inverse sine are in the range
[ -1.0 , 1.0]
. Inputs exceeding this range will result in an error.The result is given in radians, in the range
[-π/2, π/2]
.If the input value is NULL, the result is NULL.
Examples
For these examples, consider the following table and contents:
CREATE TABLE trig(i INT, f DOUBLE);
INSERT INTO trig VALUES (0,0.0), (1,-0.866)
, (2,-0.707), (3,-0.5)
, (4,0.5), (5,0.707)
, (6, 0.866), (7, 1);
Inverse sine of 1 (= π/2)
numbers=> SELECT ASIN(1);
asin
-------------------
1.5707963267948966
Computing inverse sine for a column
numbers=> SELECT f, ASIN(f) FROM trig;
f | asin
------+------
0 | 0
-0.87 | -1.05
-0.71 | -0.79
-0.5 | -0.52
0.5 | 0.52
0.71 | 0.79
0.87 | 1.05
1 | 1.57