SIGN
Returns the sign of a number.
PostgreSQL 17.5
SIGN(num)Parameters
- numnumeric | double precision
- Number
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.5
SELECT SIGN(-2);Sign of a positive number
PostgreSQL 17.5
SELECT SIGN(2);Sign of zero
PostgreSQL 17.5
SELECT SIGN(0);