Hi,
I think Bruce meant contrib/intarray which provides incredibly fast
indexed access to arrays of integers, which is your case.
We use it a lot, particularly in our full text search engine (OpenFTS).
regards,
Oleg
On Sat, 20 Oct 2001, Steve Howe wrote:
> > > I also quote the PotgreSQL user manual
> > >
> (http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/arrays.html):
> >
> > In the contrib/ directory are procedures to search arrays for values.
> > This may help.
>
>
> Thanks for the tip, but in fact I've seen them (and they're listed on the
> same document I pointed on the original message).
> These are sequential (slow) searches, and can't be indexed. in resume:
> nothing but another crude hack :). I could even use it, but I can';t tell my
> users "oh this feature works but you must compile this contrib code inyo
> your servers". Many users can't do it, and many don't even know how to do it
> :(
>
> Best Regards,
> Steve Howe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
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
