COT¶
Returns the cotangent value of a numeric expression
Syntax¶
COT( expr )
Arguments¶
Parameter |
Description |
|---|---|
|
Numeric expression representing an angle in radians |
Returns¶
Always returns a floating point result of the cotangent.
Notes¶
The result is in the range
[0, infinity).If the input value is NULL, the result is NULL.
Examples¶
For these examples, consider the following table and contents:
CREATE TABLE trig(f DOUBLE);
INSERT INTO trig VALUES (0), (PI()/12), (PI()/8), (PI()/6)
, (PI()/4), (PI()/3), (3*PI()/8), (5*PI()/12), (PI()/2);
Cotangent of π/4 (= 1)¶
Tip
Use RADIANS to convert degrees to radians
numbers=> SELECT COT(PI()/4), COT(RADIANS(45));
cot | cot0
----+-----
1 | 1
Computing cotangents for a column, in radians¶
numbers=> SELECT f, COT(f) FROM trig;
f | cot
-------+------------------
0 | 16331239353195370
0.2618 | 3.7321
0.3927 | 2.4142
0.5236 | 1.7321
0.7854 | 1
1.0472 | 0.5774
1.1781 | 0.4142
1.309 | 0.2679
1.5708 | 0