PostgreSQL BITWISE SHIFT LEFT

Postgresql << operator

The bitwise shift left operator.

Syntax << operator

a<<b

Example 1

postgres=# SELECT 14<<2;
 ?column? 
----------
       56
(1 row)
// 14=1110
// 56=111000

Example 2

postgres=# SELECT 3<<2;
 ?column? 
----------
       12
(1 row)

Example 3

postgres=# SELECT 3<<12;
 ?column? 
----------
    12288
(1 row)

Example 4

postgres=# SELECT 4<<1;
 ?column? 
----------
        8
(1 row)

Related Links

• Postgresql Mathematical Operators
• Learning PostgreSQL
• Tutorial Home

---

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(>>)