From d759b7eb6aee12bd52516905d790072845b4356f Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 25 Jun 2015 10:44:03 -0400 Subject: [PATCH] Docs: fix claim that to_char('FM') removes trailing zeroes. Of course, what it removes is leading zeroes. Seems to have been a thinko in commit ffe92d15d53625d5ae0c23f4e1984ed43614a33d. Noted by Hubert Depesz Lubaczewski. --- doc/src/sgml/func.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index ae9dba2446..80b551e78c 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -5731,7 +5731,7 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); FM prefix - fill mode (suppress padding blanks and trailing zeroes) + fill mode (suppress leading zeroes and padding blanks) FMMonth @@ -6134,7 +6134,7 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); FM prefix - fill mode (suppress padding blanks and trailing zeroes) + fill mode (suppress leading zeroes and padding blanks) FM9999 -- 2.40.0