Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ SQL Reference/ Functions and Operators/ Arithmetic Functions and Operators/ Arithmetic Operators
Updated on 2025-08-19 GMT+08:00
View PDF

Arithmetic Operators

+

Description: Addition

Example:

1
2
3
4
5
 
gaussdb=# SELECT 2+3 AS RESULT;
 result 
--------
      5
(1 row)

-

Description: Subtraction

Example:

1
2
3
4
5
 
gaussdb=# SELECT 2-3 AS RESULT;
 result 
--------
     -1
(1 row)

*

Description: Multiplication

Example:

1
2
3
4
5
 
gaussdb=# SELECT 2*3 AS RESULT;
 result 
--------
      6
(1 row)

/

Description: Division (The result is not rounded.)

Example:

1
2
3
4
5
 
gaussdb=# SELECT 4/2 AS RESULT;
 result 
--------
      2
(1 row)

1
2
3
4
5
 
gaussdb=# SELECT 4/3 AS RESULT;
      result      
------------------
 1.33333333333333
(1 row)

+/-

Description: Positive/Negative

Example:

1
2
3
4
5
 
gaussdb=# SELECT -2 AS RESULT;
 result 
--------
     -2
(1 row)

%

Description: Model (to obtain the remainder)

Example:

1
2
3
4
5
 
gaussdb=# SELECT 5%4 AS RESULT;
 result 
--------
      1
(1 row)

@

Description: Absolute value

Example:

1
2
3
4
5
 
gaussdb=# SELECT @ -5.0 AS RESULT;
 result 
--------
    5.0
(1 row)

^

Description: Power (exponent calculation)

Example:

1
2
3
4
5
 
gaussdb=# SELECT 2.0^3.0 AS RESULT;
       result       
--------------------
 8.0000000000000000
(1 row)

|/

Description: Square root

Example:

1
2
3
4
5
 
gaussdb=# SELECT |/ 25.0 AS RESULT;
 result 
--------
      5
(1 row)

||/

Description: Cubic root

Example:

1
2
3
4
5
 
gaussdb=# SELECT ||/ 27.0 AS RESULT;
 result 
--------
      3
(1 row)

!

Description: Factorial

Example:

1
2
3
4
5
 
gaussdb=# SELECT 5! AS RESULT;
 result 
--------
    120
(1 row)

!!

Description: Factorial (prefix operator)

Example:

1
2
3
4
5
 
gaussdb=# SELECT !!5 AS RESULT;
 result 
--------
    120
(1 row)

&

Description: Binary AND

Example:

1
2
3
4
5
 
gaussdb=# SELECT 91&15  AS RESULT;
 result 
--------
     11
(1 row)

|

Description: Binary OR

Example:

1
2
3
4
5
 
gaussdb=# SELECT 32|3  AS RESULT;
 result 
--------
     35
(1 row)

#

Description: Binary XOR

Example:

1
2
3
4
5
 
gaussdb=# SELECT 17#5  AS RESULT;
 result 
--------
     20
(1 row)

~

Description: Binary NOT

Example:

1
2
3
4
5
 
gaussdb=# SELECT ~1 AS RESULT;
 result 
--------
     -2
(1 row)

<<

Description: Binary shift left

Example:

1
2
3
4
5
 
gaussdb=# SELECT 1<<4 AS RESULT;
 result 
--------
     16
(1 row)

>>

Description: Binary shift right

Example:

1
2
3
4
5
 
gaussdb=# SELECT 8>>2 AS RESULT;
 result 
--------
      2
(1 row)