Re: relaxed full text search?

Steven Marcus <steven@silvertrak.com.au> writes:
> My first implementation of full text search is generally working -- but I'd
> like to be able to relax the matching rules.
> For example, searching for "salmon" does not find "salmonella" as
> configured out of the box for postgresql 9.3.10.

Hm, well, I don't think most people would think those were the same
word...

You can get that type of result by searching for "salmon:*", but if your
idea of "match" is "prefix string match" then I wonder whether you want
the FTS machinery at all.  There are other ways to get that behavior with
less overhead.

            regards, tom lane