Re: Comparing bit in an integer field

[Amitabh Kant <amitabhkant@xxxxxxxxx>]

On Mon, Nov 16, 2009 at 7:53 PM, A. Kretschmer <andreas.kretschmer@xxxxxxxxxxxxxx> wrote:

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

Thanks. That should solve my problem. 

Amitabh