+ (plus sign) unary operator

  • Article

Returns the value of expr. This function is a synonym for positive function.

Syntax

+ 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 +(1);
 1

> SELECT +(-1);
 -1

> SELECT +INTERVAL '5' MONTH;
 0-5