Re: Full text search on partial URLs - Mailing list pgsql-general

From bricklen
Subject Re: Full text search on partial URLs
Date
Msg-id CAGrpgQ-46WBaHT=nf7ms3X2LQPiWQYYwNt3B2XT1dVUXJNKMnA@mail.gmail.com
Whole thread Raw
In response to Full text search on partial URLs  (Zev Benjamin <zev-pgsql@strangersgate.com>)
Responses Re: Full text search on partial URLs
List pgsql-general

On Wed, Nov 6, 2013 at 10:45 AM, Zev Benjamin <zev-pgsql@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?

pgsql-general by date:

Previous
From: Zev Benjamin
Date:
Subject: Full text search on partial URLs
Next
From: Zev Benjamin
Date:
Subject: Re: Full text search on partial URLs