diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-10-24 21:19:15 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-10-24 21:19:15 +0000 |
| commit | 6b704bf50180e33021b90354994d232f531e70ae (patch) | |
| tree | dc6ec117083f9901a3dc6718782566e286f46e7e /doc/src | |
| parent | 3a0fde3b515825eb48234e830632bcef6db85a8f (diff) | |
| download | postgresql-6b704bf50180e33021b90354994d232f531e70ae.tar.gz postgresql-6b704bf50180e33021b90354994d232f531e70ae.zip | |
Add note about sort order of character datatypes being locale-dependent,
per suggestion from Nicolaus Erichsen.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/select.sgml | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 0ffc9cecb73..9ace534bc31 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"> |