From f26203ef32e70127e44a084ceae2be8fafba1928 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 | 41 ++++++++++++++++++++++++++++++++++++++++- 1 file changed, 40 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 340efac6556..b362d8ac034 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ - + Functions and Operators @@ -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