2009/8/11 Tom Lane <t...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers