[DOCS] functions-formatting.html

2009-09-14 Thread david
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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Re: [DOCS] functions-formatting.html

2009-09-14 Thread Tom Lane
[email protected] 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs