Re: [HACKERS] create custom collation from case insensitive portuguese

2010-11-02 Thread Dimitri Fontaine
Alexandre Riveira writes: > When mentioned in Portuguese case-insensitive in fact we are also talking > about accent-insensitive See unaccent dictionary, but don't use only this one in your text search configuration, IIRC. http://www.postgresql.org/docs/9/static/unaccent.html Regards, -- Dim

Re: [HACKERS] create custom collation from case insensitive portuguese

2010-11-02 Thread Alexandre Riveira
Thank you all for your help ! When mentioned in Portuguese case-insensitive in fact we are also talking about accent-insensitive A common example is that the name Jose and José also can be written, citext or ilike only not solve the problem My progress is ... Edit file /usr/share/i18n/loca

Re: [HACKERS] create custom collation from case insensitive portuguese

2010-11-02 Thread Robert Haas
On Tue, Nov 2, 2010 at 8:40 AM, Euler Taveira de Oliveira 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 discus

Re: [HACKERS] create custom collation from case insensitive portuguese

2010-11-02 Thread 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 [1] [2]. > So far, I understood the mechanism o