Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit38c268d

Browse files
committed
doc: adjust to_timestamp()/to_date() wording
Discussion:https://postgr.es/m/20190706202425.GA16933@telsasoft.comAuthor: Justin PryzbyBackpatch-through: 12
1 parentba09342 commit38c268d

File tree

1 file changed

+6
-6
lines changed

1 file changed

+6
-6
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -6420,20 +6420,20 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}');
64206420
</para>
64216421
<para>
64226422
If <literal>FX</literal> is specified, a separator in the template string
6423-
matches exactly one character in input string.Notice we don't insist the
6424-
input string character be the same as the template string separator.
6423+
matches exactly one character intheinput string.But note that the
6424+
input string characteris not required tobe the same as theseparator from thetemplate string.
64256425
For example, <literal>to_timestamp('2000/JUN', 'FXYYYY MON')</literal>
64266426
works, but <literal>to_timestamp('2000/JUN', 'FXYYYY&nbsp;&nbsp;MON')</literal>
6427-
returns an error because the secondtemplate string space is consumed
6428-
bythe letter <literal>J</literal>in the input string.
6427+
returns an error because the secondspace in the template string consumes
6428+
the letter <literal>J</literal>from the input string.
64296429
</para>
64306430
</listitem>
64316431

64326432
<listitem>
64336433
<para>
64346434
A <literal>TZH</literal> template pattern can match a signed number.
6435-
Without the <literal>FX</literal> option,it can lead to ambiguity in
6436-
interpretation of the minus sign, which can also be interpreted as a separator.
6435+
Without the <literal>FX</literal> option,minus signs may be ambiguous,
6436+
and could be interpreted as a separator.
64376437
This ambiguity is resolved as follows: If the number of separators before
64386438
<literal>TZH</literal> in the template string is less than the number of
64396439
separators before the minus sign in the input string, the minus sign

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp