I know that tom is going to say this is not a bug in pg and he is probably
right. but still i want to state, that in pg 8.1 the

select lower(upper('ß'))

does not return 'ss'. because the upper('ß') does not return 'SS' in the
first place. I know, german is a terrible language, but still - we are using
it :-)

thx,
klaus

and tom. there is no offence at all! I love Pg and the work you are doing.
thank you!

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Hi Klaus,

I must have missed the bug submitted about this, but as a student of
German I took particular interest in your post.

I'm unaware of any upper case or lower case for 'ß', just as there is no
upper or lower case for '@'. So, I'd expect the function to pass it
through. It's not - or shouldn't be - the business of upper() or lower()
to translate your characters for you which haven't got an appropriate
upper or lower case version...

Rgds,
Richard

On Fri, 18 Aug 2006, Klaus Ita wrote:

--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy (AT) ScienceTools (DOT) com, http://ScienceTools.com/


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Richard Troy wrote:
It's a matter of taste whether you leave 'ß' as is or replace it by 'SS'
when upper casing. PostgreSQL does upper-casing character by
character, so there is no support for one-to-many conversions.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org