diff options
Diffstat (limited to 'doc/src/sgml/ref/select.sgml')
-rw-r--r-- | doc/src/sgml/ref/select.sgml | 26 |
1 files changed, 25 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 75ef1ee1f21..68ec391238b 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.109 2008/11/19 12:21:57 petere Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.110 2008/11/20 14:04:45 petere Exp $ PostgreSQL documentation --> @@ -12,6 +12,7 @@ PostgreSQL documentation <refnamediv> <refname>SELECT</refname> + <refname>TABLE</refname> <refname>WITH</refname> <refpurpose>retrieve rows from a table or view</refpurpose> </refnamediv> @@ -21,6 +22,10 @@ PostgreSQL documentation </indexterm> <indexterm zone="sql-select"> + <primary>TABLE command</primary> + </indexterm> + + <indexterm zone="sql-select"> <primary>WITH</primary> <secondary>in SELECT</secondary> </indexterm> @@ -53,6 +58,8 @@ where <replaceable class="parameter">from_item</replaceable> can be one of: and <replaceable class="parameter">with_query</replaceable> is: <replaceable class="parameter">with_query_name</replaceable> [ ( <replaceable class="parameter">column_name</replaceable> [, ...] ) ] AS ( <replaceable class="parameter">select</replaceable> ) + +TABLE <replaceable class="parameter">table_name</replaceable> | <replaceable class="parameter">with_query_name</replaceable> </synopsis> </refsynopsisdiv> @@ -1071,6 +1078,23 @@ ROLLBACK TO s; </para> </caution> </refsect2> + + <refsect2 id="SQL-TABLE"> + <title><literal>TABLE</literal> Command</title> + + <para> + The command +<programlisting> +TABLE <replaceable class="parameter">name</replaceable> +</programlisting> + is completely equivalent to +<programlisting> +SELECT * FROM <replaceable class="parameter">name</replaceable> +</programlisting> + It can be used as a top-level command or as a space-saving syntax + variant in parts of complex queries. + </para> + </refsect2> </refsect1> <refsect1> |