=?ISO-8859-1?Q?Daniel_V=E1zquez?= <[email protected]> writes:
> Hi guys, I'm going to crazy about FTS with prefix agains email values on
> tsvector.
tsvector is meant for searching for natural-language words. It is not a
good idea to imagine that it works exactly like a substring match,
especially on strings that aren't simple words. (Frankly, I think the
prefix feature is a piece of junk, precisely because it encourages
people to think cases like this will work.)
Possibly you'd be happier with trigrams ...
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
