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

Commitd0217d5

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

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
@@ -6444,20 +6444,20 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}');
64446444
</para>
64456445
<para>
64466446
If <literal>FX</literal> is specified, a separator in the template string
6447-
matches exactly one character in input string.Notice we don't insist the
6448-
input string character be the same as the template string separator.
6447+
matches exactly one character intheinput string.But note that the
6448+
input string characteris not required tobe the same as theseparator from thetemplate string.
64496449
For example, <literal>to_timestamp('2000/JUN', 'FXYYYY MON')</literal>
64506450
works, but <literal>to_timestamp('2000/JUN', 'FXYYYY&nbsp;&nbsp;MON')</literal>
6451-
returns an error because the secondtemplate string space is consumed
6452-
bythe letter <literal>J</literal>in the input string.
6451+
returns an error because the secondspace in the template string consumes
6452+
the letter <literal>J</literal>from the input string.
64536453
</para>
64546454
</listitem>
64556455

64566456
<listitem>
64576457
<para>
64586458
A <literal>TZH</literal> template pattern can match a signed number.
6459-
Without the <literal>FX</literal> option,it can lead to ambiguity in
6460-
interpretation of the minus sign, which can also be interpreted as a separator.
6459+
Without the <literal>FX</literal> option,minus signs may be ambiguous,
6460+
and could be interpreted as a separator.
64616461
This ambiguity is resolved as follows: If the number of separators before
64626462
<literal>TZH</literal> in the template string is less than the number of
64636463
separators before the minus sign in the input string, the minus sign

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp