PostgreSQL Function Reference

SIGN

Returns the sign of a number (-1, 0, or 1).

PostgreSQL 17.5

SIGN(num)

num

The number

Examples

PostgreSQL 17.5

SELECT SIGN(-2)