=?ISO-8859-1?Q?Daniel_V=E1zquez?= <daniel2d2art@xxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
