On Tue, Nov 2, 2010 at 8:40 AM, Euler Taveira de Oliveira
> Alexandre Riveira escreveu:
>> I've achieved some success in changing collate operating system (linux)
>> to generate sort of way of Brazil Portuguese hopes by adding the
>> following code in LC_COLLATE
> This was already discussed; search the archives  .
>> So far, I understood the mechanism of change collate and reproduce in
>> postgresql, and I could not generate a case-insensitive search, I
>> believe that would change within the LC_COLLATE variable, but could not
>> go any further than that.
> PostgreSQL doesn't support case-insensitive searches specifying the collate
> per column yet. Look at . But you could use ILIKE or regular expression to
> achieve that.
Is citext also useful for this?
The Enterprise PostgreSQL Company
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2010-11-02 18:07:04|
|Subject: Re: Hash support for arrays|
|Previous:||From: Robert Haas||Date: 2010-11-02 17:54:51|
|Subject: Re: ALTER TYPE recursion to typed tables|