From: | "GEV(dot)NET" <info(at)gevnet(dot)nl> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #9793: to_number wrong convertion |
Date: | 2014-03-31 15:25:48 |
Message-ID: | 000f01cf4cf5$7e519cd0$7af4d670$@nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I am installing with the default settings so it is automatically local
settings right ?
On 1 PC it is 9.2 and its working fine but on the other PC it is 9.3 and it
is not working. Both are installed with default settings and both PC have a
locale NL.
Met vriendelijke groet,
George
Business Park
Lijndonk 4 Unit 1.19
4825 BG Breda
[M]: 06-20626078 [T]: 0767370228
[w]: www.rkassa.nl [E]: info(at)rkassa(dot)nl
-----Oorspronkelijk bericht-----
Van: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Verzonden: maandag 31 maart 2014 17:15
Aan: info(at)gevnet(dot)nl
CC: pgsql-bugs(at)postgresql(dot)org
Onderwerp: Re: [BUGS] BUG #9793: to_number wrong convertion
info(at)gevnet(dot)nl writes:
> My local is NL, so decimal separator is ',' whene i am calling
> to_number('123,45','999999D99') i am getting 12345 insted of 123.45
> in de numeric filend in the database.
> In 9.2 is working correctly and in 9.3 no mo more.
AFAIK the behavior of that case didn't change in 9.3. Are you sure you have
the locale settings of your database (particularly lc_numeric) the same as
you had in 9.2?
regards, tom lane
-----
Geen virus gevonden in dit bericht.
Gecontroleerd door AVG - www.avg.com
Versie: 2014.0.4354 / Virusdatabase: 3722/7273 - datum van uitgifte:
03/30/14
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-03-31 15:29:16 | Re: BUG #9793: to_number wrong convertion |
Previous Message | Tom Lane | 2014-03-31 15:15:23 | Re: BUG #9793: to_number wrong convertion |