Re: [GENERAL] Full text and removing dashes from names

2013-02-21 Thread Kevin Grittner
Asmir Mustafic 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

[GENERAL] Full text and removing dashes from names

2013-02-21 Thread Asmir Mustafic
Hi everybody! I have a little problem with postgres 9.0 full text functionalities. I have a document containing this string: "marko-jennifer/mary" I have to match that document with words like "marko", "jennifer" or "mary", but i can't find a way to do it. Doing a dubug query i get: select t