Re: WIP patch: Collation support - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: WIP patch: Collation support
Date
Msg-id 48BD43A8.50807@gmx.net
Whole thread Raw
In response to Re: WIP patch: Collation support  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: WIP patch: Collation support  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
Martijn van Oosterhout wrote:
> On Tue, Sep 02, 2008 at 02:50:47PM +0300, Peter Eisentraut wrote:
>> Radek Strnad wrote:
>>> - new collations can be defined with command CREATE COLLATION <collation 
>>> name> FOR <character set specification>  FROM <existing collation name> 
>>> [STRCOLFN <fn name>]
>>> [ <pad characteristic> ] [ <case sensitive> ] [ LCCOLLATE <lc_collate> ] 
>>> [ LCCTYPE <lc_ctype> ]
>> How do you plan to make a collation case sensitive or accent sensitive? 
>>  I have previously commented that this is not a realistic view on how 
>> collations work.  Since you are apparently planning to use the system 
>> locales, I don't see how you can make this work.
> 
> While it's true POSIX locales don't handle this, other collation
> libraries do and we should support them if the user wants.

Do they handle exactly those two attributes specifically?  Can you point 
out references?  Or do you mean, other collation libraries allow their 
collations to be configured/customized?  I think linguistically it is a 
very narrow view of the world to hardcode those two attributes.


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Page layout footprint
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCH] Cleanup of GUC units code