Re: [GENERAL] What is the effect of locale on numbers?

2010-09-21 Thread Tom Lane
A B writes: > I use swedish locale > show lc_numeric; > lc_numeric > - > sv_SE.UTF-8 > and I get a . (dot) in all floating-point numbers. The regular output of numbers is intentionally not locale-aware. You can use to_char() to obtain locale-specific formats.

[GENERAL] What is the effect of locale on numbers?

2010-09-21 Thread A B
Hello. I use swedish locale show lc_numeric; lc_numeric - sv_SE.UTF-8 and I get a . (dot) in all floating-point numbers. This makes me wonder, when can I see the effects of the locale? That is, I get select 355/113.0 as pie; pie 3,1415929203539823