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

Commit6b704bf

Browse files
committed
Add note about sort order of character datatypes being locale-dependent,
per suggestion from Nicolaus Erichsen.
1 parent3a0fde3 commit6b704bf

File tree

1 file changed

+8
-2
lines changed

1 file changed

+8
-2
lines changed

‎doc/src/sgml/ref/select.sgml

Lines changed: 8 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
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 $
33
PostgreSQL documentation
44
-->
55

@@ -618,7 +618,7 @@ ORDER BY <replaceable class="PARAMETER">expression</replaceable> [ ASC | DESC |
618618
<para>
619619
The ordinal number refers to the ordinal (left-to-right) position
620620
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.
622622
This is never absolutely necessary because it is always possible
623623
to assign a name to a result column using the AS clause, e.g.:
624624
<programlisting>
@@ -663,6 +663,12 @@ SELECT name FROM distributors ORDER BY code;
663663
descending sort order nulls sort at the beginning.
664664
</para>
665665

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+
666672
</refsect2>
667673

668674
<refsect2 id="SQL-UNION">

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp