diff options
| author | Bruce Momjian <bruce@momjian.us> | 2019-07-08 23:04:02 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2019-07-08 23:04:02 -0400 |
| commit | 38c268dde0ae749a93acd750afd1aad9c8f01049 (patch) | |
| tree | 46ab2d3595bbbade8568f0935608c23776add9fc /doc/src | |
| parent | ba0934251823145461b208d55d8c003576bbfd62 (diff) | |
| download | postgresql-38c268dde0ae749a93acd750afd1aad9c8f01049.tar.gz postgresql-38c268dde0ae749a93acd750afd1aad9c8f01049.zip | |
doc: adjust to_timestamp()/to_date() wording
Discussion: https://postgr.es/m/20190706202425.GA16933@telsasoft.com
Author: Justin Pryzby
Backpatch-through: 12
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index eeb3c46316a..185a184daae 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -6420,20 +6420,20 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}'); </para> <para> If <literal>FX</literal> is specified, a separator in the template string - matches exactly one character in input string. Notice we don't insist the - input string character be the same as the template string separator. + matches exactly one character in the input string. But note that the + input string character is not required to be the same as the separator from the template string. For example, <literal>to_timestamp('2000/JUN', 'FXYYYY MON')</literal> works, but <literal>to_timestamp('2000/JUN', 'FXYYYY MON')</literal> - returns an error because the second template string space is consumed - by the letter <literal>J</literal> in the input string. + returns an error because the second space in the template string consumes + the letter <literal>J</literal> from the input string. </para> </listitem> <listitem> <para> A <literal>TZH</literal> template pattern can match a signed number. - Without the <literal>FX</literal> option, it can lead to ambiguity in - interpretation of the minus sign, which can also be interpreted as a separator. + Without the <literal>FX</literal> option, minus signs may be ambiguous, + and could be interpreted as a separator. This ambiguity is resolved as follows: If the number of separators before <literal>TZH</literal> in the template string is less than the number of separators before the minus sign in the input string, the minus sign |