Re: Word Indexing

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Chris Ruprecht <chrup999(at)yahoo(dot)com>, p-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Word Indexing
Date: 2001-07-03 16:45:58
Message-ID: 200107031645.f63Gjwo24206@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Tue, 3 Jul 2001, Chris Ruprecht wrote:
>
> > Hi all, specially the developers!
> >
> > There is a feature which I would like to see - but which, I suppose, will not make it into PostGreSQL any time soon. It would mean to re-write a lot of the indexing (my guess). It's called 'Word Indexing" and it's functionality would allow something like
> >
> > Select * from text_table
> > where text_table.text contains 'Red'
> > and text_table.text contains 'Blue*'
> > and text_table.text not contains 'Green';
> >
> > I actually have an application where this would come in extremely handy. Can anybody give me a clue if this is planned for any time in the foreseeable future?
>
> We're a thinking about integration our ful-text search engine into postgres.
> currently you can use something like we do in fts.postgresql.org.
> We plan to release in Open Source as soon as we prepare documentation.
> In short, look at contrib/intarray

Oleg, great. Glad you are working on that. I know Marc has some thing
installed and I really want to have that feature native in 7.2.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Ruprecht 2001-07-03 18:15:01 Re: Word Indexing
Previous Message Tom Lane 2001-07-03 16:18:46 Re: Problems running postgres on XFS+LVM on Linux