On Monday, September 11, 2017, <
devvapp@gmail.com> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/functions-formatting.html
Description:
select to_char(3148.5, '9G999D999'); does not return what was mentioned in
the table, When I ran this expression it returned 3,148.500 and the
documentation has' 3 148,500'. Similarly many other functions return
different result than what is specified in the documentation. Please update
this. I'm using 9.5.9 version.
The to_char examples in that table show examples from a variety of locales without specifying which one they are using. The result shown can be obtained if your locale uses space and comma for group and decimal separators. Yours does not so you get the result you see. This could be improved.
David J.