Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id E801CA684DE for ; Mon, 21 May 2012 13:09:40 -0300 (ADT) Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SWVAw-0001hi-Us for pgsql-docs@postgresql.org; Mon, 21 May 2012 16:09:40 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id q4LG9PmE017586; Mon, 21 May 2012 12:09:25 -0400 (EDT) To: Josh Kupershmidt cc: pgsql-docs Subject: Re: ALTER TABLE ... CLUSTER ON synopsis In-reply-to: References: Comments: In-reply-to Josh Kupershmidt message dated "Sun, 20 May 2012 19:12:56 -0700" Date: Mon, 21 May 2012 12:09:25 -0400 Message-ID: <17585.1337616565@sss.pgh.pa.us> From: Tom Lane X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/24 X-Sequence-Number: 7349 Josh Kupershmidt writes: > The reference page for ALTER TABLE[1] correctly has the synopsis: > CLUSTER ON index_name > but later leaves off the "ON" keyword: > CLUSTER > I think the latter description should match the former, especially > since 'ON' is mandatory; small patch attached. Done, though I'm not sure we've ever tried to be consistent for such things. The main inconsistency I notice on that page is that some of the subform descriptions repeat the whole syntax while others only show the initial keyword(s). Should we try to be more consistent about that, and if so, in which direction? regards, tom lane