Re: [SQL] Case in-sensitive

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Carmen Wai" <wai_carmen(at)hotmail(dot)com>, <pgsql-sql(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: [SQL] Case in-sensitive
Date: 2002-07-25 02:21:52
Message-ID: GNELIHDDFBOCMGBFGEFOAEFFCDAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

> Can I config the Postgresql so that it can match case
> in-sensitive pattern
> automatically? i.e. I don't need to explicit convert the pattern to lower
> case like this: .....WHERE lower(textfield) LIKE lower(pattern)

All you need to do is this:

......WHERE textfield ILIKE pattern

Chris

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2002-07-25 02:27:42 Re: [SQL] Case in-sensitive
Previous Message cnliou 2002-07-25 01:32:13 Re: Concurrency Questions

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-07-25 02:27:42 Re: [SQL] Case in-sensitive
Previous Message marc sturm 2002-07-25 00:48:19 convert a bigint into a timestamp