:DevX: Implementing Full Text Indexing with PostgreSQL
DevX: Implementing Full Text Indexing with PostgreSQL Aug 12, 2004, 06 :15 UTC (3 Talkback[s]) (10369 reads) (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
