Обсуждение: Unicode upper/lower solution proposal

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

Milos Prudek <prudek@bvx.cz> writes:
> PostgreSQL does not correctly use upper() and lower() for Unicode 
> characters.

This is already fixed in CVS tip.
        regards, tom lane

> 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

Milos Prudek wrote:
> 
> > 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 ?

CVS tip is jus the current version of all CVS files.  It means this will
be in 7.5.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073