function sign(expression)

sign() returns the signum of a number — zero if the expression is zero, -1 for any negative number, and 1 for any positive number.

Arguments:
expression: A numeric expression.

Example Query:
    RETURN sign(-17), sign(0.1)