diff options
Diffstat (limited to 'doc/src/sgml/queries.sgml')
| -rw-r--r-- | doc/src/sgml/queries.sgml | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index 5c48ae1d625..c427303db3a 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.40 2007/01/09 02:14:10 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.41 2007/01/09 16:59:20 tgl Exp $ --> <chapter id="queries"> <title>Queries</title> @@ -1263,6 +1263,13 @@ SELECT a, b FROM table1 ORDER BY a + b, c; </para> <para> + Note that the ordering options are considered independently for each + sort column. For example <literal>ORDER BY x, y DESC</> means + <literal>ORDER BY x ASC, y DESC</>, which is not the same as + <literal>ORDER BY x DESC, y DESC</>. + </para> + + <para> For backwards compatibility with the SQL92 version of the standard, a <replaceable>sort_expression</> can instead be the name or number of an output column, as in |