Thread: BUG #9793: to_number wrong convertion

BUG #9793: to_number wrong convertion

From
info@gevnet.nl
Date:
The following bug has been logged on the website:

Bug reference:      9793
Logged by:          George
Email address:      info@gevnet.nl
PostgreSQL version: 9.3.1
Operating system:   Windows 7
Description:

Hi,

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.

Thanks,
George

Re: BUG #9793: to_number wrong convertion

From
Tom Lane
Date:
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

Re: BUG #9793: to_number wrong convertion

From
Tom Lane
Date:
"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

Re: BUG #9793: to_number wrong convertion

From
"GEV.NET"
Date:
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