postgres.git / summary / log / commit / refs

commit    7b6fb76349fccc38f0ef96166f207c6acd21968c
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Wed Nov 11 03:11:39 2015 +0000
First released in: 9.6.0, 9.4.6, 9.5.0

    Docs: fix misleading example.
    
    Commit 8457d0beca731bf0 introduced an example which, while not incorrect,
    failed to exhibit the behavior it meant to describe, as a result of omitting
    an E'' prefix that needed to be there.  Noticed and fixed by Peter Geoghegan.
    
    I (tgl) failed to resist the temptation to wordsmith nearby text a bit
    while at it.


 doc/src/sgml/datatype.sgml | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 4d883ecb8b1..b5191f45369 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1100,14 +1100,15 @@ SELECT '52093.89'::money::numeric::float8;
     stored and displayed that way.  However, trailing spaces are treated as
     semantically insignificant and disregarded when comparing two values
     of type <type>character</type>.  In collations where whitespace
-    is significant, this behavior can produce unexpected results,
-    e.g. <command>SELECT 'a '::CHAR(2) collate "C" &lt;
-    'a\n'::CHAR(2)</command> returns true.
+    is significant, this behavior can produce unexpected results;
+    for example <command>SELECT 'a '::CHAR(2) collate "C" &lt;
+    E'a\n'::CHAR(2)</command> returns true, even though <literal>C</>
+    locale would consider a space to be greater than a newline.
     Trailing spaces are removed when converting a <type>character</type> value
     to one of the other string types.  Note that trailing spaces
     <emphasis>are</> semantically significant in
     <type>character varying</type> and <type>text</type> values, and
-    when using pattern matching, e.g. <literal>LIKE</>,
+    when using pattern matching, that is <literal>LIKE</> and
     regular expressions.
    </para>
 


[parent: b05ae27e9a57]