Asmir Mustafic <asmir@xxxxxxxxxx> wrote: > I can't use language based stemming because names should not be > be stemmed) If you have a column that explicitly contains names, I recommend trigram similarity searching. I have found trigram similarity much better than document-oriented full text searches, LIKE, or regular expressions for names. If you want a general document search that uses some special rules in addition to what you get out of the dictionaries, I have had good results picking out relavent parts using regular expressions, building that into a string and casting it to tsvector, then concatenating that tsvector with what came from the lexeme/dictionary evaluation. -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
