Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?

Rod Taylor wrote:
> 
> > 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.
> 
> select .... [ <stmt group>, ... ]
> 
> <stmt group> :
>    [ FOR UPDATE | LIMIT ]
> 
> 
> The above, or something along those lines, would show order
> independence.

It is this kind of added abstraction that I definitely want to avoid. 
SELECT has enough complexity without adding to it.  If this change was
required, I would suggest just backing out the entire patch and leaving
it alone.

--  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,
Pennsylvania19073