(All this was done with PostgreSQL 9.0.1 on Ubuntu 10.04, FWIW.) I've tried writing my own lexize function for PostgreSQL specifically for names, based on the double metaphone algorithm. To produce the C lexize function, I started with the dict_xsyn example, and basically swapped double metaphone in for the synonym lookup. But maybe 20...
Can you use ExtractingRequestHandler and Tika with any of the compressed file formats (zip, tar, gz, etc) to extract the content out for indexing? I am sending solr the archived.tar file using curl. curl " http://localhost:8983/solr/update/extract?literal.id=doc1&fmap.content=body_texts&commit=true" -H 'Content-type:application/...
Hi everybody I tried these two methods on Advantureworks and got different results. select * from Person.[Address] where AddressLine1 like '%99%' select * from Person.[Address] where contains(Address.AddressLine1,'"*99*"') Any Idea? ...
I'm using the SQL Full-Text Search and have a stored proceedure that uses the FREETEXTTABLE function. This all works great, however, I have noticed that if I search for something such as 'Chapter 19' the 19 seems as if it is thrown away and the search only searches on 'Chapter'. Also if I search for just '19' I get no results. I know ...
I have an iPhone app that will store data in a database. The data is basically locations, activities you can do at those locations and text about the activities. eg In Florida you can scuba dive at these locations and here's some info on scuba diving in Coral Key. The user drills into the application to get to the information: Florida...
I have two tables: Job, and JobKeyword. JobKeyword contains three fields: Id, JobId and Keyword, so every Job has its JobKeyword-s. How can I use SQL Server Full Text Search so it will query the Job table, with keywords from the JobKeyword table? This is my current SQL: WITH JobRN AS ( SELECT TOP (@End) searchTable.*, ROW_NUMBER()...
SELECT DISTINCT sectionID FROM ( (SELECT sectionID,MATCH (content) AGAINST ('blah') AS relevance FROM sectioncontent WHERE MATCH (content) AGAINST ('blah')) AS alias UNION DISTINCT (SELECT sectionID,MATCH (name, description) AGAINST ('blah') AS relevance FROM sections WHERE MATCH (name, description) AGAINST ('blah')) ) I would even...
Hi everyone. This is more of a theory question rather than practice. I'm working on a project which is quite a simple catalog of links. The whole model is similar to the Dmoz or Yahoo catalog, except that each entry has certain additional attributes. I have hierarchical taxonomy working on all entries with many-to-many relationship, all...
I tried to use full text search for a table called "Business" in Sql sever 2008 here is the statement(the search term is in chinese) select * from Business biz where CONTAINS(biz.*,'家具') And the I use like statement to do the same select * from Business where Name like '%家具%' The Fulltext searc returns 8 results and the like searc...