Re: WIP patch: Collation support

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(at)svana(dot)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(at)svana(dot)org> http://svana.org/kleptog/
>> > Please line up in a tree and maintain the heap invariant while
>> > boarding. Thank you for flying nlogn airlines.
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.6 (GNU/Linux)
>>
>> iD8DBQFIvSrIIB7bNG8LQkwRAnkWAJ9FaiR9cOHFN2vkVmQaK5y7N9OJoQCbB+Ks
>> e0E4722hY/Q+Cz8tpzA0CGs=
>> =2Svh
>> -----END PGP SIGNATURE-----
>>
>>
>