From 6b704bf50180e33021b90354994d232f531e70ae Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Thu, 24 Oct 2002 21:19:15 +0000
Subject: [PATCH] Add note about sort order of character datatypes being
 locale-dependent, per suggestion from Nicolaus Erichsen.

---
 doc/src/sgml/ref/select.sgml | 10 ++++++++--
 1 file changed, 8 insertions(+), 2 deletions(-)

diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml
index 0ffc9cecb7..9ace534bc3 100644
--- a/doc/src/sgml/ref/select.sgml
+++ b/doc/src/sgml/ref/select.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.62 2002/10/18 18:26:22 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.63 2002/10/24 21:19:15 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -618,7 +618,7 @@ ORDER BY <replaceable class="PARAMETER">expression</replaceable> [ ASC | DESC |
    <para>
     The ordinal number refers to the ordinal (left-to-right) position
     of the result column. This feature makes it possible to define an ordering
-    on the basis of a column that does not have a proper name.
+    on the basis of a column that does not have a unique name.
     This is never absolutely necessary because it is always possible
     to assign a name to a result column using the AS clause, e.g.:
     <programlisting>
@@ -663,6 +663,12 @@ SELECT name FROM distributors ORDER BY code;
    descending sort order nulls sort at the beginning.
    </para>
 
+   <para>
+    Data of character types is sorted according to the locale-specific
+    collation order that was established when the database cluster
+    was initialized.
+   </para>
+
   </refsect2>
   
   <refsect2 id="SQL-UNION">
-- 
2.40.0