Re: full text searching

Gunnar R|nning <gunnar@candleweb.no>

From: Gunnar R|nning <gunnar@candleweb.no>
To: "Mitch Vincent" <mitch@venux.net>
Cc: "Culley Harrelson" <culleyharrelson@yahoo.com>, <pgsql-general@postgresql.org>
Date: 2001-02-06T13:29:33Z
Lists: pgsql-hackers
"Mitch Vincent" <mitch@venux.net> writes:

> -- Isn't going to catch anything but the literal string "woman".. (it's case
> sensitive too, mind you)
> 
> SELECT * from people WHERE whatever LIKE 'wom%n';
> 
> -- Should check either.

Well you wouldn't want to start  building these kind of rules in your
application - better to have them in the search engine. The fulltextindex
in the contrib package does of course not offer anything like this, it
would be nice to see a third party addon provide fulltext capabilities for
Postgresql. 

regards, 

	Gunnar