Bitwise operators in Postgres
11,635
You'll need to do a comparison:
SELECT DISTINCT number, ..., special FROM clients WHERE special & 2048 = 2048;
or
SELECT DISTINCT number, ..., special FROM clients WHERE special & 2048 > 0;
Author by
Elitmiar
Updated on June 08, 2022Comments
-
Elitmiar about 2 years
I have a problem with using Bitwise operators in Postgres I get the following error message
ERROR: argument of WHERE must be type boolean, not type integer
My query looks as below
SELECT DISTINCT number,name,contact,special FROM clients WHERE special & 2048;
Any help will be appreciated