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

Commit915cd10

Browse files
committed
Adjust CHAR() doc mention of pattern matching issues for trailing
spaces.
1 parent7465ae0 commit915cd10

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed

‎doc/src/sgml/datatype.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1014,12 +1014,12 @@ SELECT '52093.89'::money::numeric::float8;
10141014
with spaces to the specified width <replaceable>n</>, and are
10151015
stored and displayed that way. However, the padding spaces are
10161016
treated as semantically insignificant. Trailing spaces are
1017-
disregarded whennon-patterncomparing two values of type <type>character</type>,
1017+
disregarded when comparing two values of type <type>character</type>,
10181018
and they will be removed when converting a <type>character</type> value
10191019
to one of the other string types. Note that trailing spaces
10201020
<emphasis>are</> semantically significant in
10211021
<type>character varying</type> and <type>text</type> values, and
1022-
when using pattern matching comparisons, e.g. <literal>LIKE</>,
1022+
when using pattern matching, e.g. <literal>LIKE</>,
10231023
regular expressions.
10241024
</para>
10251025

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp