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 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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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@rkassa.nl

-----Oorspronkelijk bericht-----
Van: Tom Lane [mailto:tgl@sss.pgh.pa.us]
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
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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

"GEV.NET" <info@gevnet.nl> writes:

I am installing with the default settings so it is automatically local
settings right ?

Well, that's unproven. Did you actually do "show lc_numeric" on either
server?

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs