operators and bit field

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема operators and bit field
Дата
Msg-id FE51PJXRFB31TNHDB0PJIFTPWV31942Z.3e4d3f8f@cal-lab
обсуждение исходный текст
Ответы Re: operators and bit field
Re: operators and bit field
Список pgsql-general
I haven't seen what operators can be applied to bit masks.

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';



В списке pgsql-general по дате отправления:

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: [OpenFTS-general] Alpha version of contrib/tsearch is available for testing
Следующее
От: wsheldah@lexmark.com
Дата:
Сообщение: Re: MS-Access