Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: magnus(dot)enbom(at)rockstorm(dot)se, Jan Wieck <JanWieck(at)Yahoo(dot)com>,PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Date: 2002-08-28 02:45:24
Message-ID: 200208280245.g7S2jO803463@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-sql
OK, patch attached.  It was actually easier than I thought.  We have to
decide if we are going to remove the old syntax in 7.4.

Regression tests pass.  No doc updates yet.

---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:
> > OK, no one has commented on this, so I guess I am going to have to guess
> > the group's preference.
> >
> > My guess, seeing as very few probably use LIMIT and FOR UPDATE together,
> > is to swap them and document it in the release notes.  Was I correct in
> > my guess?
> 
> I'm sure very few people do it - but are you sure you can't just allow both
> syntaxes?
> 
> Chris
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-08-28 03:00:58
Subject: Re: fix for palloc() of user-supplied length
Previous:From: Gavin SherryDate: 2002-08-28 01:59:40
Subject: Re: Proposed GUC Variable

pgsql-sql by date

Next:From: Josh BerkusDate: 2002-08-28 03:30:32
Subject: Calculation Error on Epoch?
Previous:From: Christopher Kings-LynneDate: 2002-08-28 01:45:55
Subject: Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group