+ (plus sign) unary operator

October 10, 2023

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