sign()

Returns the sign of x as -1, 0 or 1

Reference: DuckDB 2.0.0

Arguments & returns

12 overloads

sign(x)

Scalar
Overload link x Returns
#01 BIGINT TINYINT
#02 DOUBLE TINYINT
#03 FLOAT TINYINT
#04 HUGEINT TINYINT
#05 INTEGER TINYINT
#06 SMALLINT TINYINT
#07 TINYINT TINYINT
#08 UBIGINT TINYINT
#09 UHUGEINT TINYINT
#10 UINTEGER TINYINT
#11 USMALLINT TINYINT
#12 UTINYINT TINYINT

Example

sign example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Engine example ยท Run to view results.