Re: [GENERAL] Number format problem

2006-02-06 Thread Daniel Verite
Peter Eisentraut wrote: > Stéphane SCHILDKNECHT wrote: > > select to_char(1485.12, '9G999D99'); > > > But, surprinsingly, I got 1,1485,12. > > The fr_FR locale is broken. You should report this to glibc. On my debian sarge with LC_NUMERIC set to [EMAIL PROTECTED], a printf("%'g\n", 1

Re: [GENERAL] Number format problem

2006-02-03 Thread Peter Eisentraut
Stéphane SCHILDKNECHT wrote: > select to_char(1485.12, '9G999D99'); > But, surprinsingly, I got 1,1485,12. The fr_FR locale is broken. You should report this to glibc. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)---

[GENERAL] Number format problem

2006-02-03 Thread Stéphane SCHILDKNECHT
Hi, There seems to be some tricky behaviour with number formating and french locale. I tried the following request: select to_char(1485.12, '9G999D99'); I was expecting to get: 1 485,12 But, surprinsingly, I got 1,1485,12. My postgresql server is an 8.1.2 version. The same problem occurs unde

[GENERAL] Number format problem

2006-02-03 Thread Stéphane SCHILDKNECHT
Hi, There seems to be some tricky behaviour with number formating ant french locale. i tried the following request: select to_char(1485.12, '9G999D99'); I was expecting to get: 1 485,12 But, surprinsingly, I got 1,1485,12. My postgresql server is an 8.1.2 version. The same problem occurs un