Received: from oddjob.adhesivemedia.com (oddjob.adhesivemedia.com [207.202.159.77]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5CL4sE94233 for ; Tue, 12 Jun 2001 17:04:54 -0400 (EDT) (envelope-from philip@adhesivemedia.com) Received: from localhost (philip@localhost) by oddjob.adhesivemedia.com (8.11.1/8.11.1) with ESMTP id f5CL4nP52691; Tue, 12 Jun 2001 14:04:49 -0700 (PDT) (envelope-from philip@adhesivemedia.com) Date: Tue, 12 Jun 2001 14:04:49 -0700 (PDT) From: Philip Hallstrom To: Najm Hashmi cc: pgsql Subject: Re: Bit Mapping operation In-Reply-To: <3B24E9C3.73ACA3E8@flipr.com> Message-ID: <20010612140315.A45875-100000@oddjob.adhesivemedia.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200106/190 X-Sequence-Number: 3446 In 7.1 it's there... using the |(or) &(and), etc.. operators. In 7.0.3 it's not although can be added easily. example: test=> select 2 | 1; ?column? ---------- 3 (1 row) test=> select 2 & 1; ?column? ---------- 0 (1 row) test=> select 3 & 1; ?column? ---------- 1 (1 row) test=> On Mon, 11 Jun 2001, Najm Hashmi wrote: > Hi all, I am just wondering if bit map operations are possible in > pl/pgsql. We are storing sixteen different (one or many ... i.e. check > boxes ) choices in a small int. For data cruchinging reasons, we need > to reverse the process to find out what what fields where selected or > checked. Is this info somewhere in the docs? > Thanks in advance. > Regards, > > -- > Najm Hashmi > Tel:514-271-9791 > www.mondo-live.com > www.flipr.com > > >