Re: operators and bit field

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: operators and bit field
Date: 2003-02-14 21:45:42
Message-ID: EALH54FDLGLHJIPOOKTNTQKHBB9PKWV.3e4d6386@cal-lab
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bruno, could you check that with explicity bitfield(n) values, please?

2/14/2003 1:37:03 PM, Bruno Wolff III <bruno(at)wolff(dot)to> wrote:

>On Fri, Feb 14, 2003 at 11:12:15 -0800,
> Dennis Gearon <gearond(at)cvc(dot)net> wrote:
>> I haven't seen what operators can be applied to bit masks.
>
>It looks like & works:
>area=> select 3&6;
> ?column?
>----------
> 2
>(1 row)
>
>>
>> In particular, I am looking to use binary AND:
>>
>> I want to AND two bitmasks together and see:
>>
>> A/ if the result has ANY bits set
>> B/ what bits are set in the results.
>>
>> SELECT other_fields
>> FROM some_table
>> WHERE
>> ( bitmask_8_columnA & bitmask_8_column B) = bitmask_8_patternONE
>> OR ( bitmask_8_columnA & bitmask_8_column B) = bitmask_8_patternTWO
>> ;
>>
>> I may try to use a single char for one of the bit masks I need,
>> is it possible to store all 256 values into a varchar(1) using
>> escaped input?
>>
>> Is it possible to AND two varchars within a select and compare the result?
>>
>> SELECT other_fields
>> FROM some_table
>> WHERE ( varchar_1_columnA & varchar_1_columnB ) = 'single_escaped_char_string';
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-02-14 21:46:47 Re: operators and bit field
Previous Message Tom Lane 2003-02-14 21:42:37 Re: Maximum size of the primary key