[Phpwebsite-developers] Using Full-text indexes

[Shaun M. <sh...@ae...>]

In MySQL (and MS SQL IIRC) you can create full text indexes on char,  
varchar and text fields for faster and more advanced searching  
(relevance calcs, boolean operators, stopwords etc). See http:// 
dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

Under Postgres, a quick google threw up this quite nasty module -  
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

Hmmm.


To improve the searching in phpWebSIte I was thinking of going to  
full text indexes but it would appear Postgres will throw a spanner  
in the works.

Anyone got any ideas or will I be doing..

if Mysql { fancy way } else { old way }




Shaun
aegis design - http://www.aegisdesign.co.uk
aegis hosting - http://www.aegishosting.co.uk