SIGN()
Sign or signum
SMALLINT
SIGN (number)
Parameter | Description |
---|---|
number |
An expression of a numeric type |
Returns the sign of the argument: -1, 0 or 1
-
number < 0
→-1
-
number = 0
→0
-
number > 0
→1
SIGN()
Sign or signum
SMALLINT
SIGN (number)
Parameter | Description |
---|---|
number |
An expression of a numeric type |
Returns the sign of the argument: -1, 0 or 1
number < 0
→ -1
number = 0
→ 0
number > 0
→ 1
SIN()
Sine
DOUBLE PRECISION
SIN (angle)
Parameter | Description |
---|---|
angle |
An angle, in radians |
The result is in the range [-1, 1].