SIGN

Returns a DOUBLE PRECISION value of -1, 0, or 1 representing the arithmetic sign of the argument.

Behavior Type

Immutable

Syntax

SIGN ( expression )

Parameters

expression

Is an expression of type DOUBLE PRECISION

Examples

SELECT SIGN(-8.4);
 sign 
------
   -1
(1 row)