| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | Carmen Wai <wai_carmen(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Case insensitive |
| Date: | 2002-08-10 15:59:05 |
| Message-ID: | 1028995146.31339.175.camel@linda |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, 2002-08-10 at 16:22, Carmen Wai wrote:
> Hi:
>
> Do anyone have any idea to configure the postgresql so that it can perform
> case-insensitive matching automatically? [other than--select * from table
> where lower(col_value) = lower(pattern)]
You can use ILIKE (WHERE col ILIKE 'pattern')
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"If ye abide in me, and my words abide in you, ye shall
ask what ye will, and it shall be done unto you."
John 15:7
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2002-08-10 16:20:02 | Re: Upgrading on RH72 |
| Previous Message | Carmen Wai | 2002-08-10 15:22:10 | Case insensitive |