| From: | "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | locale issues with float |
| Date: | 2002-10-25 13:32:01 |
| Message-ID: | 3DB947D1.7040001@sonalysts.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I believe the issue with misparsing of floats/doubles/etc has
been correctly identified as a locale issue and *incorrectly*
identified as a carriage-return/linefeed issue.
Somewhere I thought I saw Bruce say that it's already fixed...
From 7.3b2, psql as started:
rovero=# show lc_numeric
rovero-# ;
lc_numeric
-------------
en_US.UTF-8
Copy of floats in "236.555" format will fail.
Copy of floats in "236,555" format works.....
rovero=# set lc_numeric='C';
SET
rovero=# show lc_numeric;
lc_numeric
------------
C
Copy of floats in "235.555" format works.....
--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero(at)sonalysts(dot)com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johnson, Shaunn | 2002-10-25 13:53:19 | lpad question |
| Previous Message | Stephan Szabo | 2002-10-25 12:55:30 | Re: new error on compiling |