> > 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?.
Seems to use the settings in postgresql.conf, NOT pg_settings. I don't know
what they are used for.
So it seems that PostgreSQL
> # 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,'D9)') FROM orderline WHERE sku =
> '01-0082-4';
> price | to_n
# 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,'D9)') FROM orderline WHERE sku =
'01-0082-4';
price | to_number
---+--
