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.