Re: Bit Mapping operation

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Najm Hashmi <najm(at)flipr(dot)com>
Cc: pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Bit Mapping operation
Date: 2001-06-12 19:38:17
Message-ID: Pine.GSO.4.33.0106122234350.15947-100000@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Roberto Mello 2001-06-12 19:48:14 Re: PL/PGSQL
Previous Message GH 2001-06-12 19:35:13 Re: Re: [SQL] maximum number of rows in table - what about oid limits?