PostgreSQL SIGN() function

SIGN() function

The PostgreSQL sign() function is used to return the sign of a given number. It returns 1 if the number is positive and -1 if negative, and 0 if the number is zero.

Uses of SIGN() Function

• Determining Sign: To determine the sign of a given number.


• Conditional Logic: Useful in conditional logic where actions depend on whether a number is positive, negative, or zero.


• Data Analysis: Employed in data analysis to categorize numbers based on their sign.


• Mathematical Operations: To perform operations that need differentiation based on the sign of the numbers.


• Financial Calculations: Useful in financial calculations to quickly assess profit (positive) or loss (negative) scenarios.

Syntax:

sign()

PostgreSQL Version: 9.3

Pictorial presentation of PostgreSQL SIGN() function

Example: PostgreSQL SIGN() function

Code:

SELECT SIGN(14.321) AS "Positive Number";

Sample Output:

 Positive Number
-----------------
               1
(1 row)

Example : PostgreSQL SIGN() function using negative value

Code:

SELECT SIGN(-14.321) AS "Negative Number";

Sample Output:

 Negative Number
-----------------
              -1
(1 row)

Previous: ROUND function
Next: SIN function