Re: [HACKERS] Locale number format confusion

2002-08-09 Thread Karel Zak
On Thu, Aug 08, 2002 at 11:19:04PM +0200, Peter Eisentraut wrote: It seems we need a smart plan for handling the decimal point vs. comma issue. Observe: (lc_numeric = de_DE) ^^ It seems like hellish toy... :-) Karel -- Karel Zak [EMAIL PROTECTED]

[HACKERS] Locale number format confusion

2002-08-08 Thread Peter Eisentraut
It seems we need a smart plan for handling the decimal point vs. comma issue. Observe: (lc_numeric = de_DE) create table test_f (x double precision); CREATE TABLE insert into test_f values ('1.5'); ERROR: Bad float8 input format '1.5' insert into test_f values ('1,5'); INSERT 16909 1 create

Re: [HACKERS] Locale number format confusion

2002-08-08 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: I propose that we do this (probably by writing our own strtod and friends). If you want to format your numbers to local convention, to_char() can be used. Why are we allowing LC_NUMERIC to become active at all? IMHO this is a bug that you have