Re: [BUGS] wrong behavior using to_char()

2006-09-16 Thread Jorge Godoy
"Euler Taveira de Oliveira" <[EMAIL PROTECTED]> writes: > In the pt_BR locale, the thousand separator is "". So it should return The thousands separator in pt_BR is ".". > 12345,670. Looking at the source, I saw that the test cases for locale This should be "12.345,670". -- Jorge Godoy

Re: [BUGS] wrong behavior using to_char()

2006-09-15 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian wrote: > > One idea would be to handle C locale behavior differently from non-C > > locale. > > Right. I am thinking this is eomthing for 8.3. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard

Re: [BUGS] wrong behavior using to_char()

2006-09-14 Thread Euler Taveira de Oliveira
Jorge Godoy wrote: > > In the pt_BR locale, the thousand separator is "". So it should return > > The thousands separator in pt_BR is ".". > Oh, good catch. There is so much hack in my glibc. :-) -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of b

Re: [BUGS] wrong behavior using to_char()

2006-09-14 Thread Peter Eisentraut
Bruce Momjian wrote: > One idea would be to handle C locale behavior differently from non-C > locale. Right. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] wrong behavior using to_char()

2006-09-14 Thread Bruce Momjian
Tom Lane wrote: > "Euler Taveira de Oliveira" <[EMAIL PROTECTED]> writes: > > In the pt_BR locale, the thousand separator is "". So it should return > > 12345,670. Looking at the source, I saw that the test cases for locale > > properties are independent among them. I think that the correct form is

Re: [BUGS] wrong behavior using to_char()

2006-09-14 Thread Tom Lane
"Euler Taveira de Oliveira" <[EMAIL PROTECTED]> writes: > In the pt_BR locale, the thousand separator is "". So it should return > 12345,670. Looking at the source, I saw that the test cases for locale > properties are independent among them. I think that the correct form is to > have all-or-nothin

[BUGS] wrong behavior using to_char()

2006-09-14 Thread Euler Taveira de Oliveira
Hi, I notice a strange behavior using to_char() function. I'm using locale pt_BR but it could happen with any locale. template1=# select to_char(12345.67, '999G999D999'); to_char -- 12,345,670 (1 registro) In the pt_BR locale, the thousand separator is "". So it should return