Re: Full text search strategy for names - Mailing list pgsql-general

From John DeSoi
Subject Re: Full text search strategy for names
Date
Msg-id BC2D830C-A758-4426-A6D7-EDE022F07BC2@pgedit.com
Whole thread Raw
In response to Re: Full text search strategy for names  (Rick Schumeyer <rschumeyer@gmail.com>)
List pgsql-general
On Apr 17, 2009, at 7:02 AM, Rick Schumeyer wrote:

> You can get extra (undesirable) results, depending on the name.  For
> example, if you are searching for the last name of "Ricks", you will
> also find all authors whose first name is "Rick"

If you can process the names separately from the rest of the text, try

select to_tsvector('simple', 'claude Jones');

      to_tsvector
----------------------
  'jones':2 'claude':1





John DeSoi, Ph.D.





pgsql-general by date:

Previous
From: Irene Barg
Date:
Subject: Re: number of relations reported by vacuumdb -av
Next
From: Scott Marlowe
Date:
Subject: Re: Community account