MaFa wrote:
> select * from customers where upper(name) like '%JOHN%'
Thanks. I found that >>select * from documents where body ~ some_text'<<
also gives good results. I am only concerned about its effectiveness.
> **Full-text indexing is a whole other thing...
I've looked quite a bit at tsearch2.. too complicated for me for now.
--
Marcin Gil
marcin.gil @ audax.com.pl, tel. 694972082
OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
tel/fax (44) 7247530, 7244401