Re: Searching email, Full Text Search prefix, not expected results - Mailing list pgsql-general

From Tom Lane
Subject Re: Searching email, Full Text Search prefix, not expected results
Date
Msg-id 5410.1331758478@sss.pgh.pa.us
Whole thread Raw
In response to Searching email, Full Text Search prefix, not expected results  (Daniel Vázquez <daniel2d2art@gmail.com>)
List pgsql-general
=?ISO-8859-1?Q?Daniel_V=E1zquez?= <daniel2d2art@gmail.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

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Upgrade questions
Next
From: Alexander Reichstadt
Date:
Subject: pg_role vs. pg_shadow or pg_user