+ (plus sign) unary operator

Returns the value of expr.

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.

+ is a synonym for positive function.

Examples 

> SELECT +(1);
 1

> SELECT +(-1);
 -1

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