diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2009-01-12 14:06:20 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2009-01-12 14:06:20 +0000 |
| commit | 405728f66976729b15dbc95bbbe3dfa147b5106f (patch) | |
| tree | 37656640e5c57d4654bd8190ce61dc71a20a857e | |
| parent | bf21cdb7e74c37841a06d5058f0e2f5d4e59e24f (diff) | |
| download | postgresql-405728f66976729b15dbc95bbbe3dfa147b5106f.tar.gz postgresql-405728f66976729b15dbc95bbbe3dfa147b5106f.zip | |
Add some minimal documentation that the SQL standard requires parentheses
after ONLY.
| -rw-r--r-- | doc/src/sgml/ref/select.sgml | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 0a19f894e70..ba14437764f 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.116 2008/12/31 23:42:56 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.117 2009/01/12 14:06:20 petere Exp $ PostgreSQL documentation --> @@ -1458,6 +1458,19 @@ SELECT distributors.* WHERE distributors.name = 'Westward'; </refsect2> <refsect2> + <title><literal>ONLY</literal> and Parentheses</title> + + <para> + The SQL standard requires parentheses around the table name + after <literal>ONLY</literal>, as in <literal>SELECT * FROM ONLY + (tab1), ONLY (tab2) WHERE ...</literal>. PostgreSQL supports that + as well, but the parentheses are optional. (This point applies + equally to all SQL commands supporting the <literal>ONLY</literal> + option.) + </para> + </refsect2> + + <refsect2> <title>Namespace Available to <literal>GROUP BY</literal> and <literal>ORDER BY</literal></title> <para> |