> 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 @ audax.com.pl, tel. 694972082
OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
tel/fax (44) 7247530, 7244401
In response to
pgsql-novice by date
|Next:||From: Marcin Gil||Date: 2003-12-19 09:59:25|
|Subject: Re: select .. like ignore case|
|Previous:||From: Patrice Durosay||Date: 2003-12-19 09:23:12|
|Subject: Re: Can't create lock file /tmp/.s.PGSQL.5432.lock|