On Mon, Nov 16, 2009 at 7:53 PM, A. Kretschmer <
andreas.kretsch...@schollglas.com> 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
>
2009/11/16 A. Kretschmer :
> In response to Amitabh Kant :
>> Hello
>>
>> I need to compare the bit values of a integer field in my table. For
>> example, I
>> have a table called "t1" with just one field "a1" having following values:
>>
>> a1
>> ==
>> 0
>> 12
>> 8
>> 0
>> 1
>> 10
>> 7
>> 19
>>
>>
In response to Amitabh Kant :
> Hello
>
> I need to compare the bit values of a integer field in my table. For
> example, I
> have a table called "t1" with just one field "a1" having following values:
>
> a1
> ==
> 0
> 12
> 8
> 0
> 1
> 10
> 7
> 19
>
> I am trying to fetch all records where the
2009/11/16 Amitabh Kant :
> Hello
>
> I need to compare the bit values of a integer field in my table. For
> example, I have a table called "t1" with just one field "a1" having
> following values:
>
> a1
> ==
> 0
> 12
> 8
> 0
> 1
> 10
> 7
> 19
>
> I am trying to fetch all records where the 3rd bina