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