Shifting bit strings : Bit Shift « Data Type « PostgreSQL

1. PostgreSQL
2. Data Type
3. Bit Shift

Shifting bit strings

postgres=# -- Shifting bit strings
postgres=#
postgres=# SELECT b'1000' >> 2 AS "8 shifted right",  8 >> 2 AS likewise;
 8 shifted right | likewise
-----------------+----------
 0010            |        2
(1 row)

postgres=#
postgres=#

           
       

Related examples in the same category