Re: lc_numeric and decimal delimiter

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: lc_numeric and decimal delimiter
Date: 2005-11-08 21:26:56
Message-ID: 8849.1131485216@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> writes:
> I am at OpenDBCon in Germany. People are complaining about floats/numerics
> not accepting German/European conventions for the delimiter point -- a
> comma. This is hard coded into the the numeric input parser but,
> naturally, we use strtod() in else where. I'm not sure about the locale
> stuff and whether it deals with it. Are we in the wrong here?

This has been proposed and rejected in the past. I don't think it's an
open-and-shut decision. Given that our trend has been to tighten rather
than loosen input error checking (eg, no empty strings for int4, no
heuristic month/day choices for timestamps), I'd be inclined to vote
against it still.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2005-11-08 21:36:18 Re: Assert failure found in 8.1RC1
Previous Message Alvaro Herrera 2005-11-08 21:23:05 Re: lc_numeric and decimal delimiter