Re: [GENERAL] Number format problem - Mailing list pgsql-patches

From Daniel Verite
Subject Re: [GENERAL] Number format problem
Date
Msg-id 20060213032606.2165832@localhost
Whole thread Raw
In response to Re: [GENERAL] Number format problem  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [GENERAL] Number format problem  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
    Bruce Momjian wrote:

> > > Oh, so C locale has "" for thousands_sep?  Hmm.  So there is no way to
> > > disinguish "" as "don't have" from "" as "don't want".  Will revert.
> >
> > Possibly we could special-case C locale, and allow an empty string only
> > when not C locale.  However, it could be that there are other locales
> > where the change would surprise people, too :-(
>
> Not sure.  Peter stated the French locale was wrong for the Debian they
> were using, and he should know, so I am going to wait for  more feeback.

The baseline glibc sources from gnu.org have
(in glibc-2.3.6/localedata/locales/fr_FR):

LC_NUMERIC
decimal_point             "<U002C>"
thousands_sep             ""
grouping                  0;0
END LC_NUMERIC

So at first sight it's more a glibc issue rather than debian-specific.

However, this was filed as a bug in debian long ago. Incidentally, it got fixed
just this week, meaning that the future debian-glibc should use a space instead
of the empty string, as reported here:
http://lists.debian.org/debian-glibc/2006/02/msg00168.html
Which is consistent with Peter's statement that it was wrong up to now, and also
with what the OP expected in the first place.

--
 Daniel
 PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org


pgsql-patches by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: [HACKERS] slow information schema with thausand users,
Next
From: ITAGAKI Takahiro
Date:
Subject: Re: ignore_killed_tuples is always true