pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedIncorrect result in the Table 9-28. to_char examples
2+ messages / 2 participants
[nested] [flat]
* Incorrect result in the Table 9-28. to_char examples
@ 2017-09-11 20:55 devvapp@gmail.com
2017-09-14 15:03 ` Re: Incorrect result in the Table 9-28. to_char examples David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: devvapp@gmail.com @ 2017-09-11 20:55 UTC (permalink / raw)
To: pgsql-docs
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.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Incorrect result in the Table 9-28. to_char examples
2017-09-11 20:55 Incorrect result in the Table 9-28. to_char examples devvapp@gmail.com
@ 2017-09-14 15:03 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2017-09-14 15:03 UTC (permalink / raw)
To: devvapp@gmail.com <devvapp@gmail.com>; +Cc: pgsql-docs
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-09-14 15:03 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-09-11 20:55 Incorrect result in the Table 9-28. to_char examples devvapp@gmail.com
2017-09-14 15:03 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox