Re: [GENERAL] Full text searching?

[Poul L. Christiansen]

Gunnar R|nning wrote:
> 
> "Poul L. Christiansen" <[EMAIL PROTECTED]> writes:
> 
> > I chose to use a 3rd party product (Verity) for full text indexing even
> > though I would prefer to use PostgreSQL for fti.
> 
> How is the support for Danish in Verity now ?

I convert the characters - e.g. ø will be converted to &oslash; When I
do a search, i just replace the search string the same way. The only
problem that could arise is when people search for the word "slash", but
I guess you could avoid searching &oslash; somehow.

> I used Verity indirectly earlier as a plugin in to Sybase. The nice thing
> about such an integration where that I could do joins between the different
> Verity indexes and my regular tables.
> 
> It would have been nice if PostgreSQL had some sort of extension mechanism
> to interface against external servers. Maybe an API for creating proxy
> tables, so a join you do against a proxy table really forwards the request
> to another service.

I'd love to have an index type directly in PostegreSQL called fti which
give us full text indexing just as easily as a standard B-tree index. 

When 7.1 is out, all it needs is fti to make it equal in features to MS
SQL Server ;)

Poul L. Christiansen