positive function

Returns the value of expr.

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.

positive is a synonym for + (plus sign) unary operator.

Examples

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