Re: [GENERAL] Number format problem

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "PostgreSQL-patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [GENERAL] Number format problem
Date: 2006-02-13 02:26:17
Message-ID: 20060213032606.2165832@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig White 2006-02-13 02:27:01 Re: dumb question
Previous Message Tony Caduto 2006-02-13 02:11:56 Re: Why does an ON SELECT rule have to be named "_RETURN"?

Browse pgsql-patches by date

  From Date Subject
Next Message ITAGAKI Takahiro 2006-02-13 02:30:19 Re: ignore_killed_tuples is always true
Previous Message Christopher Kings-Lynne 2006-02-13 01:59:38 Re: [HACKERS] slow information schema with thausand users,