2009/8/11 Tom Lane <tgl@sss.pgh.pa.us>:
> Working through this now, and I noticed that the example added to the
> manual seems to be wrong:
>
> <entry><literal>to_char(0.000485, '9.99EEEE')</literal></entry>
> <entry><literal>' 4.850e-04'</literal></entry>
>
> With 9.99 as the pattern, I'd expect (and indeed I get) 4.85e-04
> not 4.850e-04. This is correct behavior, no?
Correct. I apologise for the oversight.
The example output should lose the trailing zero, or else the example
query needs an extra '9' after the decimal point. I don't think it
makes much difference which.
Cheers,
BJ