SIGN
Returns a DOUBLE PRECISION value of -1, 0, or 1 representing the arithmetic sign of the argument.
Behavior Type
Syntax
SIGN ( expression )
Parameters
expression |
Is an expression of type DOUBLE PRECISION |
Examples
SELECT SIGN(-8.4); sign ------ -1 (1 row)