Re: Per-column collation

Alexandre Riveira <alexandre@objectdata.com.br>

From: Alexandre Riveira <alexandre@objectdata.com.br>

To: Peter Eisentraut <peter_e@gmx.net>

Cc: "David E. Wheeler" <david@kineticode.com>, Itagaki Takahiro <itagaki.takahiro@gmail.com>, pgsql-hackers@postgresql.org

Date: 2010-12-06T19:54:27Z

Lists: pgsql-hackers

Please

It would be very important to us that the Brazilian LIKE collate worked 
with, and possible case-insensitive and accent-insensitive

Tank's

Alexandre Riveira
Brazil

Peter Eisentraut escreveu:
> On mÃ¥n, 2010-12-06 at 10:01 -0800, David E. Wheeler wrote:
>   
>> I've been wondering if this patch will support case-insensitve
>> collations. If so, then citext should probably be revised to use one.
>>     
>
> This has been touch upon several times during the discussions on past
> patches.
>
> Essentially, the current patch only arranges that you can specify a sort
> order for data.  The system always breaks ties using a binary
> comparison.  This could conceivably be changed, but it's a separate
> problem.  Some of the necessary investigation work has presumably
> already been done in the context of citext.
>
>
>
>