Hi,

i have the following test-case:

http://psql.privatepaste.com/b3b431851a

We want to convert a TO_CHAR() formated numeric back to numeric using TO_NUMBER() with the same format string. This does not work with a german locale.

By removing the FM prefix and using the exact amount of digits in the format string for TO_NUMBER() it starts to work. Switching the locale back to en_US does work too.

Is this a bug or am i missing something?

Thanks!

Best regards,
Patryk


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

Reply via email to