Re: Custom collations, collation modifiers (eg case-insensitive) - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Custom collations, collation modifiers (eg case-insensitive)
Date
Msg-id CAFj8pRAxj1OLwTOE9+riLKQ5br2My-oTCzXBV-hwzPMXoq0pfg@mail.gmail.com
Whole thread
In response to Re: Custom collations, collation modifiers (eg case-insensitive)  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers

This feature is interesting for Czech language too. Lot of applications allows accent free searching due possible issues in original data or some client limits - missing Czech keyboard and similar

Dne 21.1.2014 17:17 "Alvaro Herrera" <alvherre@2ndquadrant.com> napsal(a):
Craig Ringer wrote:

> (I intensely dislike the idea of ignoring accents, but it's something
> some people appear to need/want, and is supported by other vendors).

FWIW at least in spanish, users always want to search for entries
ignoring accents.  Nowadays I think most turn to unaccent(), but before
that was written people resorted to calling transform() on both the
stored data and the user-entered query, so that all pertinent matches
would be found.  People would even create indexes on the unaccented data
to speed this up.  It's an important feature, not a corner case by any
means.

Not sure about other languages.  For instance perhaps in French they
would be interested in ignoring some accents but not others.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Bug? could not remove shared memory segment
Next
From: Marko Tiikkaja
Date:
Subject: Re: array_length(anyarray)