The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

Arithmetic Bit-shifting

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)

Helpful Link:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/LanguageElements/Operators/BitwiseOperators.htm

Have fun!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.