Re: create custom collation from case insensitive portuguese

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Alexandre Riveira <alexandre(at)objectdata(dot)com(dot)br>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Euler Taveira de Oliveira <euler(at)timbira(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: create custom collation from case insensitive portuguese
Date: 2010-11-02 22:35:39
Message-ID: m2d3qnz744.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alexandre Riveira <alexandre(at)objectdata(dot)com(dot)br> 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,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-11-02 22:52:40 Re: [PATCH] V3: Idle in transaction cancellation
Previous Message Andres Freund 2010-11-02 22:11:56 Re: [PATCH] V3: Idle in transaction cancellation