Re: [SQL] Case in-sensitive - Mailing list pgsql-general

From Christopher Kings-Lynne
Subject Re: [SQL] Case in-sensitive
Date
Msg-id GNELIHDDFBOCMGBFGEFOAEFFCDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Case in-sensitive  ("Carmen Wai" <wai_carmen@hotmail.com>)
Responses Re: [SQL] Case in-sensitive
List pgsql-general
> 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


pgsql-general by date:

Previous
From:
Date:
Subject: Re: Concurrency Questions
Next
From: Rob Brown-Bayliss
Date:
Subject: Rolling my own replication