diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-03-27 16:35:31 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-03-27 16:35:31 +0000 |
| commit | 7a3e7b64ac14405527a428b84f6222b98c9ddbad (patch) | |
| tree | 78f19e35945cb1b50c3924e85b8920ece4215bfc /doc/src | |
| parent | bf576cc01482ffcdd7c22cf7502e6568076d49a5 (diff) | |
to_char fixes, Karel Zak
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 22 |
1 files changed, 18 insertions, 4 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 25db8b37c10..c8f242ca000 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.148 2003/03/25 16:15:36 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.149 2003/03/27 16:35:30 momjian Exp $ PostgreSQL documentation --> @@ -4365,7 +4365,7 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation> </row> <row> <entry><literal>to_char(-0.1, '99.99')</literal></entry> - <entry><literal>' -.10'</literal></entry> + <entry><literal>' -.10'</literal></entry> </row> <row> <entry><literal>to_char(-0.1, 'FM9.99')</literal></entry> @@ -4381,7 +4381,7 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation> </row> <row> <entry><literal>to_char(12, 'FM9990999.9')</literal></entry> - <entry><literal>'0012'</literal></entry> + <entry><literal>'0012.'</literal></entry> </row> <row> <entry><literal>to_char(485, '999')</literal></entry> @@ -4405,9 +4405,19 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation> </row> <row> <entry><literal>to_char(148.5, '999.999')</literal></entry> - <entry><literal>' 148.500'</literal></entry> + <entry><literal>' 148.500'</literal></entry> </row> <row> + <entry><literal>to_char(148.5, 'FM999.999')</literal></entry> + <entry><literal>'148.5'</literal></entry> + </row> + <row> + <row> + <entry><literal>to_char(148.5, 'FM999.990')</literal></entry> + <entry><literal>'148.500'</literal></entry> + </row> + <row> + <row> <entry><literal>to_char(148.5, '999D999')</literal></entry> <entry><literal>' 148,500'</literal></entry> </row> @@ -4425,6 +4435,10 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation> </row> <row> <entry><literal>to_char(485, '999MI')</literal></entry> + <entry><literal>'485 '</literal></entry> + </row> + <row> + <entry><literal>to_char(485, 'FM999MI')</literal></entry> <entry><literal>'485'</literal></entry> </row> <row> |