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
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? |