Re: full text searching

"Mitch Vincent" <mitch(at)venux(dot)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