Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 9CAEE4759B6
	for <pgsql-hackers@postgresql.org>;
	Wed, 28 Aug 2002 21:14:38 -0400 (EDT)
Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net
	[216.55.132.35])
	by postgresql.org (Postfix) with ESMTP id 7AAA9475840
	for <pgsql-hackers@postgresql.org>;
	Wed, 28 Aug 2002 21:14:37 -0400 (EDT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.10.1) id g7T1EGO29372;
	Wed, 28 Aug 2002 21:14:16 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200208290114.g7T1EGO29372@candle.pha.pa.us>
Subject: Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
In-Reply-To: <22787.1030578830@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Date: Wed, 28 Aug 2002 21:14:16 -0400 (EDT)
Cc: Robert Treat <xzilla@users.sourceforge.net>,
	Peter Eisentraut <peter_e@gmx.net>, Rod Taylor <rbt@zort.ca>,
	Larry Rosenman <ler@lerctr.org>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
X-Mailer: ELM [version 2.4ME+ PL99 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/2090
X-Sequence-Number: 27773

Tom Lane wrote:
> >> If you would like a vote, we can do that, but as I remember we had the
> >> same issue with COPY and we got most votes to just show the best syntax.
> 
> Perhaps we could compromise on showing only the new syntax in the <synopsis>
> part of the man page, and then mentioning somewhere in the body of the
> page that the other order is deprecated but accepted for backwards
> compatibility.  This same approach would work well for documenting
> COPY's old syntax.

Yes, I thought about that.  People want to show both SELECT syntaxes,
but how would you do that --- show the SELECT syntax twice with just
those last two clauses reversed --- yuck.

We could easily mention that we allow both clause orderings in the text
somewhere.

For COPY, we could just put the old syntax at the bottom of the manual
page and mention it is depricated.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073