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

From Rod Taylor
Subject Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Date
Msg-id 1030587488.1693.11.camel@jester
Whole thread Raw
In response to Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
List pgsql-hackers
> 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.


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



pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Next
From: Tom Lane
Date:
Subject: Re: Serious problem with my postgres