Postgres Pro
Downloads
Home   >   mailing lists

Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? - Mailing list pgsql-sql

From Tom Lane
Subject Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Date
Msg-id 14112.1030486027@sss.pgh.pa.us
Whole thread Raw
In response to Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Larry Rosenman <ler@lerctr.org>)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> My guess, seeing as very few probably use LIMIT and FOR UPDATE together,
> is to swap them and document it in the release notes.

That will surely piss someone off.  Can't you try a little harder to
support either order?
        regards, tom lane

pgsql-sql by date:

Previous
From: Wei Weng
Date:
Subject: IDENT authentication problem
Next
From: Larry Rosenman
Date:
Subject: Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?