PostgreSQL BITWISE AND

Postgresql & operator

Bitwise AND comparison. The number has to convert to binary number before the comparison.

Syntax & operator

a & b

Example 1

postgres=# SELECT 12 & 10 as n2;
 n2 
----
  8
(1 row)


// binary 
12=1100
10=1010
-------
 8=1000

Example 2

postgres=# SELECT 5 & 10 as n2;
 n2 
----
  0
(1 row)

Example 3

postgres=# SELECT 2 & 10 as n2;
 n2 
----
  2
(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(>>)