Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Re: create custom collation from case insensitive portuguese
On Tue, Nov 2, 2010 at 8:40 AM, Euler Taveira de Oliveira <euler(at)timbira(dot)com> wrote: > 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 [1] [2]. > >> 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 [3]. But you could use ILIKE or regular expression to > achieve that. Is citext also useful for this? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
In response to
- Re: create custom collation from case insensitive portuguese at 2010-11-02 15:40:44 from Euler Taveira de Oliveira
Responses
- Re: create custom collation from case insensitive portuguese at 2010-11-11 22:11:42 from Alexandre Riveira
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