Re: BUG #9793: to_number wrong convertion

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=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=20
Lijndonk 4=A0=A0 Unit 1.19=A0=A0=A0=A0=A0=A0=A0=A0=20
4825 BG Breda=A0=A0=A0=A0=A0=A0=20
[M]: 06-20626078=A0=A0=A0=A0=A0=A0=A0 [T]:=A0 0767370228=A0=A0=A0=A0=A0 =
=A0
[w]: www.rkassa.nl=A0=A0=A0=A0=A0=A0 [E]:=A0 info@rkassa.nl

-----Oorspronkelijk bericht-----
Van: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20
Verzonden: maandag 31 maart 2014 17:15
Aan: info@gevnet.nl
CC: pgsql-bugs@postgresql.org
Onderwerp: Re: [BUGS] BUG #9793: to_number wrong convertion

info@gevnet.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=20
> 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