Postgres Pro
Downloads
Home   >   mailing lists

Re: select .. like ignore case - Mailing list pgsql-novice

From Marcin Gil
Subject Re: select .. like ignore case
Date
Msg-id 3FE2C51B.2000006@audax.com.pl
Whole thread Raw
In response to Re: select .. like ignore case  (MaFa <mafalista@freemail.hu>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Patrice Durosay
Date:
Subject: Re: Can't create lock file /tmp/.s.PGSQL.5432.lock
Next
From: Marcin Gil
Date:
Subject: Re: select .. like ignore case