Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Date
Msg-id 200208290503.g7T535o00108@candle.pha.pa.us
Whole thread Raw
In response to Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Rod Taylor <rbt@zort.ca>)
Responses Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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
 


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: [Resend] Sprintf() auditing and a patch
Next
From: Jukka Holappa
Date:
Subject: Re: [Resend] Sprintf() auditing and a patch