Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A046D475F94 for ; Wed, 28 Aug 2002 22:16:44 -0400 (EDT) Received: from lerlaptop.lerctr.org (lerlaptop.lerctr.org [207.158.72.14]) by postgresql.org (Postfix) with ESMTP id BD6EB475806 for ; Wed, 28 Aug 2002 22:16:43 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by lerlaptop.lerctr.org (8.12.5/8.12.5) with ESMTP id g7T2GZZb002109; Wed, 28 Aug 2002 21:16:36 -0500 (CDT) (envelope-from ler@lerctr.org) Subject: Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? From: Larry Rosenman To: Robert Treat Cc: Bruce Momjian , Tom Lane , Peter Eisentraut , Rod Taylor , PostgreSQL-development In-Reply-To: <200208282229.14628.xzilla@users.sourceforge.net> References: <200208290114.g7T1EGO29372@candle.pha.pa.us> <200208282229.14628.xzilla@users.sourceforge.net> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 28 Aug 2002 21:16:35 -0500 Message-Id: <1030587397.1287.25.camel@lerlaptop.lerctr.org> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/2100 X-Sequence-Number: 27783 On Wed, 2002-08-28 at 21:29, Robert Treat wrote: > > I think after the LIMIT and FOR UPDATE explanations (but before the note about > SELECT privilege) you could add a note that "for backwards compatibility > reasons the LIMIT and FOR UPDATE clauses are interchangeable" though maybe > interchangeable isn't the best word... How about "for backwards compatibility reasons the LIMIT and FOR UPDATE clauses can appear in either order, I.E. LIMIT 1 FOR UPDATE and FOR UPDATE LIMIT 1 are equivalent". > > > For COPY, we could just put the old syntax at the bottom of the manual > > page and mention it is depricated. > > In both cases I don't know that a detailed explination is needed, but a > mention of the different possibility and perhaps a suggestion to look at an > old version of the docs for complete details should go a long way. I suspect that Bruce's suggestion is best, modulo a spell check :-). > > Robert Treat -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749