Re: Comparing bit in an integer field

In response to Amitabh Kant :

test=# select * from t1;

 a1
----
 0
 12
 8
 0
 1
 10
 7
 19

(8 rows)

test=*# select a1 from t1 where (a1>>2)::bit = B'1';

 a1
----
 12
 7
(2 rows)

Regards, Andreas