to_number

# SELECT * FROM pg_settings WHERE name LIKE 'lc_%';   name     | setting
-------------+---------lc_messages | unsetlc_monetary | Clc_numeric  | Clc_time     | C
(4 rows

SELECT price, to_number(price,'9999D9)') FROM orderline WHERE sku =
'01-0082-4';price | to_number
-------+-----------429,5 |      4295429,5 |      4295429,5 |      4295429,5 |      4295429,5 |      4295429,5 |
4295429,5|      4295429,5 |      4295429,5 |      4295429,5 |      4295 
(10 rows)

How can to_number work with Danish locale?

--
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2501
Howitzvej 75               Åben 12.00-18.00        Email: kar@kakidata.dk
2000 Frederiksberg        Lørdag 12.00-16.00       Web:      www.suse.dk