Hi everyone, I posted to this forum once before and was able to receive help. Thanks again! I'm trying to implement full text search capabilities. Basically, I have a very simple "data catalog" type of website (http:// gis.drcog.org/datacatalog), where the user can type in a word or words to search for records that match the criteria. I have a table with a few fields, but I want to be able to search/index two fields -- the "name" of the dataset and the "description." (or more, if I can index fields from other tables too, that would be great). I'd like to be able to use a full text search to rank the results in terms of relevance. What is the best way to handle this? I've read through the PostgreSQL documentation and don't quite understand it although I'm trying to understand and am 'playing around' with this on a development server. Is the default text search configuration enough? I've tried setting my own configuration but get errors about not finding .dict dictionary files? I have a default install of PostgreSQL 8.4. Also, I've created a tsvector column and created indexes, but it didn't seem to delete stop words from the indexes. Should the stop words be indexed? Also, I don't quite understand how to create indexes but rank certain words as being more important than others, for instance, maybe having words that come from the "name" column carrying more importance than words coming from the "description" column. Finally, I'd like "watersheds" to come up when someone searches for "water" so I don't think I have this configured properly, because this record is not returned. Is there a good tutorial or maybe documentation that is a bit easier to understand? I know my database is far from complicated but I can't seem to find a configuration that works well. When I try ranking my results, most of the results end up with the same rank, so something must be wrong? Can someone point me in the right direction? Thanks for the help. I appreciate it. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
