Thread: functions-formatting.html

Was reading the docs and stumbled across what I believe is a mistake.

There is a mistake in Table 9-25
the result of to_char(148.5,'999D999') should be ' 148.500',
the docs list it as ' 148,500'

http://www.postgresql.org/docs/8.4/interactive/functions-formatting.html
and
http://developer.postgresql.org/pgdocs/postgres/functions-formatting.html

david@gardnerit.net writes:
> Was reading the docs and stumbled across what I believe is a mistake.
> There is a mistake in Table 9-25
> the result of to_char(148.5,'999D999') should be ' 148.500',
> the docs list it as ' 148,500'

The example in the docs presumes a locale where comma is the radix point
(eg, fr_FR).  Perhaps that should be clarified, but changing the example
so that D appears to act the same as . doesn't seem to me to be an
improvement.

            regards, tom lane