Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group