On Wed, Nov 6, 2013 at 10:45 AM, Zev Benjamin <zev-pg...@strangersgate.com>wrote:
> Hi, > > I have Postgres full text search set up for my application and it's been > working great! However, my users would like their searches to turn up > parts of URLs. For example, they would like a search for "foobar" to turn > up a document that contains the string "http://example.com/foobar/blah"; > (and similarly for queries like "example" and "blah). With the default > dictionaries for host, url, and url_path, the search query would have to > contain the complete host or url path. > > What is the best way to accomplish this? Should I be looking at building > a custom dictionary that breaks down hosts and urls or is there something > simpler I can do? > Have you looked into trigrams? http://www.postgresql.org/docs/current/static/pgtrgm.html
