+ (plus sign) unary operator

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

SQL

> SELECT +(1);
 1

> SELECT +(-1);
 -1

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

Related functions

• negative function
• abs function
• sign function
• - (minus sign) unary operator
• positive function