SIGN

Purpose

This function returns the signum of number n as one of -1, 0, 1.

Syntax

sign::=

Example

Copy
SELECT SIGN(-123);