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

Commit7465ae0

Browse files
committed
Document that char() ignores spaces in non-pattern comparisons, not in
pattern comparisons such as LIKE and regex.
1 parent4ff90d9 commit7465ae0

File tree

1 file changed

+4
-2
lines changed

1 file changed

+4
-2
lines changed

‎doc/src/sgml/datatype.sgml

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1014,11 +1014,13 @@ 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 when comparing two values of type <type>character</type>,
1017+
disregarded whennon-patterncomparing 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
1021-
<type>character varying</type> and <type>text</type> values.
1021+
<type>character varying</type> and <type>text</type> values, and
1022+
when using pattern matching comparisons, e.g. <literal>LIKE</>,
1023+
regular expressions.
10221024
</para>
10231025

10241026
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp