> # 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