=?ISO-8859-1?Q?Daniel_V=E1zquez?= <daniel2d2art(at)gmail(dot)com> 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