Am Mittwoch, 22. Februar 2006 14:26 schrieb [EMAIL PROTECTED]:
> unfortunately I did not set the locales correct, when I created my
> database. The result is, that the numeric type expects an american
> format like "12.34".
You can't change that. The locale only affects the to_char function.
--
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> How do I change the numeric format?
You don't. You can use to_char and to_number to do locale-aware
transformations, but the base data types only handle the SQL-standard
representations of numbers.
regards, tom lane
-
