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

From Zev Benjamin
Subject Full text search on partial URLs
Date
Msg-id 527A8E4F.8070400@strangersgate.com
Whole thread Raw
Responses Re: Full text search on partial URLs
List pgsql-general
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?


Thanks,
Zev


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: After upgrade to 9.3, streaming replication fails to start
Next
From: bricklen
Date:
Subject: Re: Full text search on partial URLs