# 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