Re: [HACKERS] Unicode upper/lower solution proposal

[Milos Prudek]

This is already fixed in CVS tip.

Oh, cool!
I know what is a CVS, but what is CVS tip?
In which PostgreSQL stable release is upper() and lower() for Unicode 
planned to be included? Postgres version 7.5 ?

--
Milos Prudek
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match

[HACKERS] Unicode upper/lower solution proposal

[Milos Prudek]

Hi all,
Disclaimer: I'm not a C programmer and my knowledge of locales is 
limited. I use Python.

PostgreSQL does not correctly use upper() and lower() for Unicode 
characters. I've read the bug reports and followups at 
archive.postgresql.org.

I'd like to propose two ideas:
1) Python has upper() and lower() functions, and they work in Unicode 
perfectly. With Python being open source, could PostgreSQL developers 
pick Python developer's brains? Is Python using only standard C library 
calls to do its Unicode upper/lower conversion? Could the relevant part 
of Python source code serve as a starting point of implementing Unicode 
upper/lower in Postgres?

2) Arbitrary collation support for PostgreSQL is available at 
http://www.fi.muni.cz/~adelton/l10n/ and it works perfectly. Could it be 
used to implement Unicode upper/lower in Postgres?

--
Milos Prudek
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings