Linux Today: Linux News On Internet Time.

More on LinuxToday

DevX: Implementing Full Text Indexing with PostgreSQL

Aug 12, 2004, 06:15 (3 Talkback[s])
(Other stories by Joshua D. Drake)

"Like many companies, over the years my company developed a home-grown billing/project system that allows our programmers to bill to a Web application. This system is quite capable; however one of the drawbacks to the system is that there's no way to search the billable entries or customer notes.

"Of course, we could use simple LIKE or regex queries via SQL but that would be resource-intensive and would not provide the detailed results we would like. For example, to search for all billing entries that had a description with the words 'apache' (to protect the customer name) and 'php' we could write a query like this

Complete Story

Related Stories: