locale issues with float

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: Raw Message | Whole Thread | 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
***********************************************************************

Browse pgsql-general by date

  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