A fun way to manipulate bits in Vertica SQL is with the use of arithmetic bit-shifting, which moves the bits in a number either left or right and fills in the new values with 0s.
Bit-shifting left is an easy way to multiply by powers of 2, while bit-shifting right divides by powers of 2.
Example:
dbadmin=> SELECT 5 << 2 "5*4=";
5*4=
------
20
(1 row)
dbadmin=> SELECT 20 >> 2 "20/4=";
20/4=
-------
5
(1 row)
Have fun!
