Postgres Pro
Downloads
Home   >   mailing lists

Inconsistency between TO_CHAR() and TO_NUMBER() - Mailing list pgsql-bugs

From Patryk Kordylewski
Subject Inconsistency between TO_CHAR() and TO_NUMBER()
Date
Msg-id 51878292.6080003@fooby.de
Whole thread Raw
Responses Re: Inconsistency between TO_CHAR() and TO_NUMBER()  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #8135: current_setting('DateStyle'); does not reflect User setting
Next
From: jvalssilva@gmail.com
Date:
Subject: BUG #8137: Instalação aparece erro