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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general