Обсуждение: Bit Mapping operation
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 findout what what fields where selected or checked. Is this info somewhere in the docs? <br />Thanks in advance. <br />Regards,<pre>-- Najm Hashmi Tel:514-271-9791 www.mondo-live.com www.flipr.com</pre>
no bitmap indexes available yet.
But I'd recommend you to check contrib/intarray which
adds indexed access to array of int. You may store array of 16 int4
for each record.
Regards,
Oleg
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
>
>
>
Regards, Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
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 > > >