Bitwise operators in Postgres
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;
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;