diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-04-08 00:26:34 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-04-08 00:26:34 +0000 |
| commit | e55c8e36ae44677dca4420bed07ad09d191fdf6c (patch) | |
| tree | a33cc231676436c724a361bfd4dd74d40713d79b /doc/src | |
| parent | d7e2de6629e082322429726618e1dd75ea423cdc (diff) | |
Support syntax "CLUSTER table USING index", which is more logical.
Holger Schurig
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/cluster.sgml | 26 |
1 files changed, 15 insertions, 11 deletions
diff --git a/doc/src/sgml/ref/cluster.sgml b/doc/src/sgml/ref/cluster.sgml index b93d264ae1d..c038d387c81 100644 --- a/doc/src/sgml/ref/cluster.sgml +++ b/doc/src/sgml/ref/cluster.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/cluster.sgml,v 1.40 2007/02/01 00:28:18 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/cluster.sgml,v 1.41 2007/04/08 00:26:33 momjian Exp $ PostgreSQL documentation --> @@ -20,8 +20,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> -CLUSTER <replaceable class="PARAMETER">indexname</replaceable> ON <replaceable class="PARAMETER">tablename</replaceable> -CLUSTER <replaceable class="PARAMETER">tablename</replaceable> +CLUSTER <replaceable class="PARAMETER">tablename</replaceable> [ USING <replaceable class="PARAMETER">indexname</replaceable> ] CLUSTER </synopsis> </refsynopsisdiv> @@ -77,19 +76,19 @@ CLUSTER <variablelist> <varlistentry> - <term><replaceable class="PARAMETER">indexname</replaceable></term> + <term><replaceable class="PARAMETER">tablename</replaceable></term> <listitem> <para> - The name of an index. + The name (possibly schema-qualified) of a table. </para> </listitem> </varlistentry> <varlistentry> - <term><replaceable class="PARAMETER">tablename</replaceable></term> + <term><replaceable class="PARAMETER">indexname</replaceable></term> <listitem> <para> - The name (possibly schema-qualified) of a table. + The name of an index. </para> </listitem> </varlistentry> @@ -172,9 +171,9 @@ CREATE TABLE <replaceable class="parameter">newtable</replaceable> AS <para> Cluster the table <literal>employees</literal> on the basis of - its index <literal>emp_ind</literal>: + its index <literal>employees_ind</literal>: <programlisting> -CLUSTER emp_ind ON emp; +CLUSTER employees USING employees_ind; </programlisting> </para> @@ -182,7 +181,7 @@ CLUSTER emp_ind ON emp; Cluster the <literal>employees</literal> table using the same index that was used before: <programlisting> -CLUSTER emp; +CLUSTER employees; </programlisting> </para> @@ -198,7 +197,12 @@ CLUSTER; <title>Compatibility</title> <para> - There is no <command>CLUSTER</command> statement in the SQL standard. + The syntax: +<synopsis> +CLUSTER <replaceable class="PARAMETER">indexname</replaceable> ON <replaceable class="PARAMETER">tablename</replaceable> +</synopsis> + is also supported for compatibility with pre-8.3 <productname>PostgreSQL</> installations. + There is no <command>CLUSTER</command> statement in the SQL standard. </para> </refsect1> |