Arithmetic Bit-shifting

Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert

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.