From e8cae0d6fc098153c56f732928c9beae347222eb Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 26 Feb 2008 15:32:30 +0000 Subject: [PATCH] Add information about format modifiers that apply to numeric formats. These were previously only documented in the context of date/time formats. --- doc/src/sgml/func.sgml | 39 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 39 insertions(+) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index a5b32c903d..6306edb27b 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -5320,6 +5320,45 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); + + Certain modifiers can be applied to any template pattern to alter its + behavior. For example, FM9999 + is the 9999 pattern with the + FM modifier. + shows the + modifier patterns for numeric formatting. + + + + Template Pattern Modifiers for Numeric Formatting + + + + Modifier + Description + Example + + + + + FM prefix + fill mode (suppress padding blanks and zeroes) + FM9999 + + + TH suffix + uppercase ordinal number suffix + 999TH + + + th suffix + lowercase ordinal number suffix + 999th + + + +
+ shows some examples of the use of the to_char function. -- 2.39.5