Re: Bit Mapping operation - Mailing list pgsql-sql

From Oleg Bartunov
Subject Re: Bit Mapping operation
Date
Msg-id Pine.GSO.4.33.0106122234350.15947-100000@ra.sai.msu.su
Whole thread Raw
In response to Bit Mapping operation  (Najm Hashmi <najm@flipr.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: cascading delete - recursivity
Next
From: Martín Marqués
Date:
Subject: Re: ORDER BY what?