Binary anding - Mailing list pgsql-sql

From Trever Adams
Subject Binary anding
Date
Msg-id 36881D50.A16A77A9@teleteam.net
Whole thread Raw
List 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 by date:

Previous
From: "David Hartwig"
Date:
Subject: Re: [SQL] change username
Next
From: "Jose' Soares"
Date:
Subject: Re: [SQL] Probs with int2 in functions