Re: Per-column collation

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>

To: "David E. Wheeler" <david@kineticode.com>

Cc: Itagaki Takahiro <itagaki.takahiro@gmail.com>, Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgresql.org

Date: 2010-12-06T18:10:12Z

Lists: pgsql-hackers

2010/12/6 David E. Wheeler <david@kineticode.com>:
> On Dec 6, 2010, at 4:06 AM, Itagaki Takahiro wrote:
>
>> * contrib/citext raises an encoding error when COLLATE is specified
>> even if it is the collation as same as the database default.
>> We might need some special treatment for C locale.
>
> I've been wondering if this patch will support case-insensitve collations. If so, then citext should probably be revised to use one.

what I know - no. It's support only system based collations

Pavel

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