|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.116 2008/12/31 23:42:56 tgl Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.117 2009/01/12 14:06:20 petere Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -1457,6 +1457,19 @@ SELECT distributors.* WHERE distributors.name = 'Westward'; |
1457 | 1457 | </para> |
1458 | 1458 | </refsect2> |
1459 | 1459 |
|
| 1460 | + <refsect2> |
| 1461 | + <title><literal>ONLY</literal> and Parentheses</title> |
| 1462 | + |
| 1463 | + <para> |
| 1464 | + The SQL standard requires parentheses around the table name |
| 1465 | + after <literal>ONLY</literal>, as in <literal>SELECT * FROM ONLY |
| 1466 | + (tab1), ONLY (tab2) WHERE ...</literal>. PostgreSQL supports that |
| 1467 | + as well, but the parentheses are optional. (This point applies |
| 1468 | + equally to all SQL commands supporting the <literal>ONLY</literal> |
| 1469 | + option.) |
| 1470 | + </para> |
| 1471 | + </refsect2> |
| 1472 | + |
1460 | 1473 | <refsect2> |
1461 | 1474 | <title>Namespace Available to <literal>GROUP BY</literal> and <literal>ORDER BY</literal></title> |
1462 | 1475 |
|
|