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 <[EMAIL > PROTECTED]>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 <[EMAIL PROTECTED]> 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----- >> >> >
