SIGN
Returns the sign of a number.
PostgreSQL 17.9
SIGN(num)- num
- Numbernumeric | double precision
Return value
-1 for a negative number, 0 for zero, 1 for a positive number; the type of num, double precision for an integer argument
Examples
Sign of a negative number
PostgreSQL 17.9
SELECT SIGN(-2);Sign of a positive number
PostgreSQL 17.9
SELECT SIGN(2);Sign of zero
PostgreSQL 17.9
SELECT SIGN(0);