From 01a366c2bbff465c6e732d74da1c2f68f0efbc28 Mon Sep 17 00:00:00 2001 From: Justin Pryzby Date: Sat, 30 Mar 2019 03:42:35 -0500 Subject: [PATCH v2 08/12] Clean up language in cf984672: Improve behavior of to_timestamp()/to_date() functions --- doc/src/sgml/func.sgml | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index defc287..4b3f768 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -6399,19 +6399,19 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}'); exceeds the number of separators in the template. - If FX is specified, separator in template string - matches to exactly one character in input string. Notice we don't insist - input string character to be the same as template string separator. + If FX is specified, a separator in the template string + matches exactly one character in the input string. But note that the + character in the input string is not required to be the same character in the template string. For example, to_timestamp('2000/JUN', 'FXYYYY MON') works, but to_timestamp('2000/JUN', 'FXYYYY  MON') - returns an error because a space second template string space consumed - letter J from the input string. + returns an error because a space in its template string consumes + the letter J from the input string. - TZH template pattern can match a signed number. + The TZH template pattern can match a signed number. Without the FX option, it may lead to ambiguity in interpretation of the minus sign, which can also be interpreted as a separator. This ambiguity is resolved as follows. If the number of separators before -- 2.1.4