diff options
Diffstat (limited to 'doc/src/sgml/ref/select.sgml')
-rw-r--r-- | doc/src/sgml/ref/select.sgml | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 48a192d1b90..f862d5f8737 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.89 2005/08/01 20:31:04 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.90 2005/11/01 21:09:51 tgl Exp $ PostgreSQL documentation --> @@ -1095,7 +1095,7 @@ SELECT distributors.* WHERE distributors.name = 'Westward'; <title>Namespace Available to <literal>GROUP BY</literal> and <literal>ORDER BY</literal></title> <para> - In the SQL:2003 standard, an <literal>ORDER BY</literal> clause may + In the SQL-92 standard, an <literal>ORDER BY</literal> clause may only use result column names or numbers, while a <literal>GROUP BY</literal> clause may only use expressions based on input column names. <productname>PostgreSQL</productname> extends each of @@ -1108,11 +1108,11 @@ SELECT distributors.* WHERE distributors.name = 'Westward'; </para> <para> - SQL:2003 uses a slightly different definition which is not entirely upward - compatible with SQL-92. + SQL:1999 and later use a slightly different definition which is not + entirely upward compatible with SQL-92. In most cases, however, <productname>PostgreSQL</productname> will interpret an <literal>ORDER BY</literal> or <literal>GROUP - BY</literal> expression the same way SQL:2003 does. + BY</literal> expression the same way SQL:1999 does. </para> </refsect2> |