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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general