# 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
# 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
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 can
Hi, All
Please advise where I can get the PHP LINK module (RPM format) for
PostgreSQL V7.3. Thank you in advance!
Jack
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html