aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2010-02-16 21:18:02 +0000
committerBruce Momjian <bruce@momjian.us>2010-02-16 21:18:02 +0000
commit70d8a2c29e809c90f7caaded2b4f47b1cf18d01d (patch)
treead6915246553b0ff65b2855719abf417666c1c2b /doc/src
parent55ea144a14c5c1831a3eca5d261860b840742814 (diff)
downloadpostgresql-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.sgml8
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>