Re: [BUGS] error in upper()

2006-08-29 Thread Klaus Ita
Hi Richard, On Sat, Aug 19, 2006 at 09:49:41AM -0700, Richard Troy wrote: > 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 am sorry, I posted it with a bad sender address. I can't remember which one i used

Re: [BUGS] error in upper()

2006-08-26 Thread Peter Eisentraut
Richard Troy wrote: > I'm unaware of any upper case or lower case for 'ß' 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 ht

Re: [BUGS] error in upper()

2006-08-26 Thread Richard Troy
rom: Klaus Ita <[EMAIL PROTECTED]> > To: pgsql-bugs@postgresql.org > Subject: [BUGS] error in upper() > > 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('ß'

[BUGS] error in upper()

2006-08-19 Thread Klaus Ita
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