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