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


Sun, 23 May 2004 12:06:19 +0200
Milos Prudek <prudek@bvx.cz>
Unicode upper/lower solution proposal
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

Sun, 23 May 2004 12:06:40 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Unicode upper/lower solution proposal 

> 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


Sun, 23 May 2004 18:29:02 +0200
Milos Prudek <prudek@bvx.cz>
Re: Unicode upper/lower solution proposal
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, Pennsylvania 19073

Sun, 23 May 2004 23:23:49 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Unicode upper/lower solution proposal