sql - Postgres 中的位运算符

Question

我在 Postgres 中使用按位运算符时遇到问题，我收到以下错误消息

ERROR:  argument of WHERE must be type boolean, not type integer

我的查询如下所示

SELECT DISTINCT number,name,contact,special FROM clients WHERE special & 2048;

任何帮助将不胜感激

Answer 1

您需要进行比较:

SELECT DISTINCT number, ..., special FROM clients WHERE special & 2048 = 2048;

或

SELECT DISTINCT number, ..., special FROM clients WHERE special & 2048 > 0;