> # SELECT * FROM pg_settings WHERE name LIKE 'lc_%'; > name | setting > -------------+--------- > lc_messages | unset > lc_monetary | C > lc_numeric | C > lc_time | C > (4 rows > > SELECT price, to_number(price,'9999D9)') FROM orderline WHERE sku = > '01-0082-4'; > price | to_number > -------+----------- > 429,5 | 4295 > 429,5 | 4295 > 429,5 | 4295 > 429,5 | 4295 > 429,5 | 4295 > 429,5 | 4295 > 429,5 | 4295 > 429,5 | 4295 > 429,5 | 4295 > 429,5 | 4295 > (10 rows) > > How can to_number work with Danish locale?
It looks like you have "C" locale instead of Danish one. What happens when you change your system locale to Danish?. Regards, Tomasz Myrta ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
