Received: from mail.teleteam.net (root@mail.teleteam.net [199.34.16.10]) by hub.org (8.9.1/8.9.1) with ESMTP id TAA07700 for ; Mon, 28 Dec 1998 19:07:17 -0500 (EST) (envelope-from highlander@teleteam.net) Received: from teleteam.net (cust-208-208-110-45.teleteam.net [208.208.110.45]) by mail.teleteam.net (8.8.8/8.8.6) with ESMTP id SAA24542 for ; Mon, 28 Dec 1998 18:01:20 -0600 (CST) Sender: arabian@mail.teleteam.net Message-ID: <36881D50.A16A77A9@teleteam.net> Date: Mon, 28 Dec 1998 18:07:44 -0600 From: Trever Adams X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.1.131 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Binary anding Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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