functions-formatting.html

[David Gardner-6]

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


--
Sent via pgsql-docs mailing list (pgsql-docs@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

[Tom Lane-2]

david@... 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

--
Sent via pgsql-docs mailing list (pgsql-docs@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs