Euler Taveira de Oliveira wrote: > Hi, > > Looking again at bug report [1], I agree that's a glibc bug. Numbers in > pt_BR has its format 1.234.567,89; sometimes the format 1234567,89 is > acceptable too, ie, the thousand separator is optional. I guess that > some locales use the 'optional' thousand separator too (yep, they are > all broken too).
Yeah, formatting.c revs 1.106 and 1.105 contains this (it was already pointed out in the previous thread): revision 1.106 date: 2006-02-12 20:48:23 -0300; author: momjian; state: Exp; lines: +3 -4; Revert because C locale uses "" for thousands_sep, meaning "n/a", while French uses "" for "don't want". Seems we have to keep the existing behavior. ---------------------------- revision 1.105 date: 2006-02-12 16:52:06 -0300; author: momjian; state: Exp; lines: +5 -4; Support "" for thousands separator and plus sign in to_char(), per report from French Debian user. psql already handles "" fine. I'm not sure that your proposed patch is OK for the C locale. It was proposed that the C locale should be handled as an exception, but it seems nothing got done in that direction. Are we going to do something for 8.3? -- Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4 "La experiencia nos dice que el hombre peló millones de veces las patatas, pero era forzoso admitir la posibilidad de que en un caso entre millones, las patatas pelarían al hombre" (Ijon Tichy) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly