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 по дате отправления: