SIGN

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

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)