Returns the sign of a number according to the table below.Documentation Index
Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
Use this file to discover all available pages before exploring further.
Syntax
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
value | Any expression that evaluates to a numeric data type. | DOUBLE PRECISION |
Return Type
DOUBLE PRECISION
Examples
The following examples highlight what can be returned with theSIGN function:
| If | Returns |
|---|---|
<value> < 0 | -1 |
<value> = 0 | 0 |
<value> > 0 | 1 |
1
Example
-1
Example
0