diff options
author | Bruce Momjian <bruce@momjian.us> | 2010-02-16 21:18:02 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2010-02-16 21:18:02 +0000 |
commit | 70d8a2c29e809c90f7caaded2b4f47b1cf18d01d (patch) | |
tree | ad6915246553b0ff65b2855719abf417666c1c2b /doc/src | |
parent | 55ea144a14c5c1831a3eca5d261860b840742814 (diff) | |
download | postgresql-70d8a2c29e809c90f7caaded2b4f47b1cf18d01d.tar.gz postgresql-70d8a2c29e809c90f7caaded2b4f47b1cf18d01d.zip |
Honor to_char() "FM" specification in YYY, YY, and Y; it was already
honored by YYYY. Also document Oracle "toggle" FM behavior.
Per report from Guy Rouillier
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/func.sgml | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index a4ea1462a8b..71952ee1fc4 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.502 2010/02/12 17:33:19 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.503 2010/02/16 21:18:01 momjian Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -5174,7 +5174,11 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); <para> <literal>FM</literal> suppresses leading zeroes and trailing blanks that would otherwise be added to make the output of a pattern be - fixed-width. + fixed-width. In <productname>PostgreSQL</productname>, + <literal>FM</literal> modifies only the next specification, while in + Oracle <literal>FM</literal> affects all subsequent + specifications, and repeated <literal>FM</literal> modifiers + toggle fill mode on and off. </para> </listitem> |