|
1 | 1 | <!--
|
2 |
| -$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.62 2002/10/18 18:26:22 tgl Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.63 2002/10/24 21:19:15 tgl Exp $ |
3 | 3 | PostgreSQL documentation
|
4 | 4 | -->
|
5 | 5 |
|
@@ -618,7 +618,7 @@ ORDER BY <replaceable class="PARAMETER">expression</replaceable> [ ASC | DESC |
|
618 | 618 | <para>
|
619 | 619 | The ordinal number refers to the ordinal (left-to-right) position
|
620 | 620 | of the result column. This feature makes it possible to define an ordering
|
621 |
| - on the basis of a column that does not have aproper name. |
| 621 | + on the basis of a column that does not have aunique name. |
622 | 622 | This is never absolutely necessary because it is always possible
|
623 | 623 | to assign a name to a result column using the AS clause, e.g.:
|
624 | 624 | <programlisting>
|
@@ -663,6 +663,12 @@ SELECT name FROM distributors ORDER BY code;
|
663 | 663 | descending sort order nulls sort at the beginning.
|
664 | 664 | </para>
|
665 | 665 |
|
| 666 | + <para> |
| 667 | + Data of character types is sorted according to the locale-specific |
| 668 | + collation order that was established when the database cluster |
| 669 | + was initialized. |
| 670 | + </para> |
| 671 | + |
666 | 672 | </refsect2>
|
667 | 673 |
|
668 | 674 | <refsect2 id="SQL-UNION">
|
|