Re: keyword (or fulltext) indexes, any planned developments?

On Tuesday 26 February 2002 20:39, Marc Beneteau wrote:
> Are there any plans to provide support for keyword indexes in Postgre?  The
> idea is to efficiently index every word in a long text column, in order to
> support queries such as :
>
> Select... from Products where ProductDescription like "%wool%" and
> ProductDescription like "%black%"
>
> This will work but it requires a table scan.

Take a look at OpenFTS ( http://openfts.sourceforge.net/ )

Ian Barwick