select .. like ignore case

#1

Is there a way to issue select .. like to ignore letter case?
Or do I have to use full text indexing?

Regards,
--
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

#2

Quote:

Is there a way to issue select .. like to ignore letter case?
**For example:

select * from customers where upper(name) like '%JOHN%'

Quote:

Or do I have to use full text indexing?
**Full-text indexing is a whole other thing...

Bye:
MaFa

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

#3

MaFa wrote:

Quote:

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.

Quote:

**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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

#4

MaFa wrote:

Quote:

Is there a way to issue select .. like to ignore letter case?

**For example:
select * from customers where upper(name) like '%JOHN%'

The other answer I received was:

select ... ilike..

simple, eh?
--
Marcin Gil :: marcin.gil (AT) audax (DOT) com.pl
OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
tel (44) 7247530 w/22, 7244401 w/22 -- fax w/25

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

select .. like ignore case

comp.databases.postgresql.novice comp.databases.postgresql.novice

select .. like ignore case - 12-19-2003 , 02:52 AM

Re: select .. like ignore case - 12-19-2003 , 03:06 AM

Re: select .. like ignore case - 12-19-2003 , 03:30 AM

Re: select .. like ignore case - 12-19-2003 , 03:59 AM