11<!--
2- $Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.148 2003/03/25 16:15:36 petere Exp $
2+ $Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.149 2003/03/27 16:35:30 momjian Exp $
33PostgreSQL documentation
44-->
55
@@ -4365,7 +4365,7 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation>
43654365 </row>
43664366 <row>
43674367 <entry><literal>to_char(-0.1, '99.99')</literal></entry>
4368- <entry><literal>' -.10'</literal></entry>
4368+ <entry><literal>' -.10'</literal></entry>
43694369 </row>
43704370 <row>
43714371 <entry><literal>to_char(-0.1, 'FM9.99')</literal></entry>
@@ -4381,7 +4381,7 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation>
43814381 </row>
43824382 <row>
43834383 <entry><literal>to_char(12, 'FM9990999.9')</literal></entry>
4384- <entry><literal>'0012'</literal></entry>
4384+ <entry><literal>'0012. '</literal></entry>
43854385 </row>
43864386 <row>
43874387 <entry><literal>to_char(485, '999')</literal></entry>
@@ -4405,8 +4405,18 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation>
44054405 </row>
44064406 <row>
44074407 <entry><literal>to_char(148.5, '999.999')</literal></entry>
4408- <entry><literal>'
4408+ <entry><literal>' 148.500'</literal></entry>
44094409 </row>
4410+ <row>
4411+ <entry><literal>to_char(148.5, 'FM999.999')</literal></entry>
4412+ <entry><literal>'148.5'</literal></entry>
4413+ </row>
4414+ <row>
4415+ <row>
4416+ <entry><literal>to_char(148.5, 'FM999.990')</literal></entry>
4417+ <entry><literal>'148.500'</literal></entry>
4418+ </row>
4419+ <row>
44104420 <row>
44114421 <entry><literal>to_char(148.5, '999D999')</literal></entry>
44124422 <entry><literal>' 148,500'</literal></entry>
@@ -4425,6 +4435,10 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation>
44254435 </row>
44264436 <row>
44274437 <entry><literal>to_char(485, '999MI')</literal></entry>
4438+ <entry><literal>'485 '</literal></entry>
4439+ </row>
4440+ <row>
4441+ <entry><literal>to_char(485, 'FM999MI')</literal></entry>
44284442 <entry><literal>'485'</literal></entry>
44294443 </row>
44304444 <row>