Re: Incorrect result in the Table 9-28. to_char examples

On Monday, September 11, 2017, <devvapp(at)gmail(dot)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, &#39;9G999D999&#39;); does not return what was
> mentioned in
> the table, When I ran this expression it returned 3,148.500 and the
> documentation has&#39; 3 148,500&#39;. Similarly many other functions
> return
> different result than what is specified in the documentation. Please update
> this. I&#39;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.