Binary anding

Поиск
Список
Период
Сортировка
От Trever Adams
Тема Binary anding
Дата
Msg-id 36881D50.A16A77A9@teleteam.net
обсуждение исходный текст
Список pgsql-sql
Is it possible to do anding for a where in a select statement?  Here is
what I want to do in a hybrid C/SQL statement.

select * from somesuchtable where mask&someothermask;

I just want at least one bit set after that anding of the masks.  If it
is, I want that item.  (Note I will actually be using negating wheres as
well so that not all that fit the above will be retrieved.)

Is this possible?

Please let me know asap.
Trever

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

Предыдущее
От: "David Hartwig"
Дата:
Сообщение: Re: [SQL] change username
Следующее
От: "Jose' Soares"
Дата:
Сообщение: Re: [SQL] Probs with int2 in functions