I think at least case sensitivity can be done by comparing two strings converted to upper case with toupper() function.
Regards
Radek Strnad
On Tue, Sep 2, 2008 at 2:00 PM, Martijn van Oosterhout <kleptog@svana.org> 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.
Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
