positive function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns the value of expr. This function is a synonym for + (plus sign) unary operator.

Syntax 

positive(expr)

Arguments

  • expr: An expression that evaluates to a numeric or interval.

Returns

The result type matches the argument.

This function is a no-op.

Examples 

> SELECT positive(1);
 1
> SELECT positive(-1);
 -1