Re: Full text search on partial URLs

On Wed, Nov 6, 2013 at 10:45 AM, Zev Benjamin
<zev-pgsql(at)strangersgate(dot)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