Jump to: navigation, search

PostgreSQL MULTIPLICATION

From w3cyberlearnings

Contents

Postgresql * operator

Multiplication or times two or more number. The number must not be null.

Syntax * operator

a * b

Example 1

postgres=# SELECT 3*2*4 e3;
 e3 
----
 24
(1 row)

postgres=# SELECT 3*2*43 e3;
 e3  
-----
 258
(1 row)

Related Links


  1. addition(+)
  2. subtraction(-)
  3. multiplication(*)
  4. division(/)
  1. modulo(%)
  2. exponentiation(^)
  3. square root(|/)
  4. cube root(||/)
  1. factorial(!)
  2. absolute value(@)
  3. bitwise AND(&)
  4. bitwise OR(|)
  1. bitwise XOR(#)
  2. bitwise NOT(~)
  3. bitwise shift left(<<)
  4. bitwise shift right(>>)
Navigation
Web
SQL
MISC
References