Functions/Numbers & math/sign

Numbers & math Scalar

sign()

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

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

SELECT sign(-349);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3