View Forum Topic

Forums
CS520
URL FTS only results in match when searching for full url

Author	Message
rframe Posts: 18	Posted 19:48 May 31, 2012 \| Regarding searching the URL's in items, the url is only found if the entire url is searched for and not is a key word is found. Is this what is to be expected?? As an example I have an entry with the title 'test url' the url is 'http://www.google.com' select * from site_items where tsv @@ plainto_tsquery('google'); results in 0 entries found select * from site_items where tsv @@ plainto_tsquery('http://www.google.com'); results in the entry being found Thank you
cysun Posts: 2935	Posted 20:17 May 31, 2012 \| This is fine for this assignment. PostgreSQL only indexes three things about a URL: host, path, and full URL (e.g. try `select to_tsvector('http://www.google.com/foo/bar.html');` ). In a real application if you want the users to be able to search for "google", you need to tokenize the URL yourself.
rframe Posts: 18	Posted 21:24 May 31, 2012 \| Great, thank you for the reply on this and the other post
Fatemah Posts: 59	Posted 17:19 Jun 01, 2012 \| Dear professor, I need you to clarify something for me please. You said it is fine for this assignment to type the whole URL in the search field in order to search for a URL. Does that mean that if there is a word in the content of the URL, not the URL itself, it is OK if it says no results found?
Fatemah Posts: 59	Posted 18:21 Jun 01, 2012 \| Found the answer, thanks!
Fatemah Posts: 59	Posted 18:29 Jun 01, 2012 \| I tried to search for a single word in url in FireFox browser and I found the expected result. For example, in the search field if you type "google" instead of "http://www.google.com", it will display that it found a result. If you search for a word in a page of a url, it will display that it found a result. Hope this helps!
cysun Posts: 2935	Posted 13:45 Jun 03, 2012 \| Fatemah wrote: I tried to search for a single word in url in FireFox browser and I found the expected result. For example, in the search field if you type "google" instead of "http://www.google.com", it will display that it found a result. If you search for a word in a page of a url, it will display that it found a result. Hope this helps! Well, if your search works better than what I would expect, it of course is perfectly fine.