On Mon, 2007-02-26 at 11:29 -0500, Madison Kelly wrote:
> I am looking at writing a search engine of sorts for my database. I
> have only ever written very simple search engines before which amounted
> to not much more that the query string being used with ILIKE on a pile
> of columns. This was pretty rudimentary and didn't offer anything like
> relevance sorting and such (I'd sort by result name, age or whatnot).
Look at Tsearch2:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
It has a lot of features for searching, and can make use of powerful
indexes to return search results very quickly. As someone already
mentioned, it also has ranking features.
Regards,
Jeff Davis