Re: [GENERAL] UPDATE/DELETE with ORDER BY and LIMIT

2010-09-28 Thread Bartlomiej Korupczynski
On Sat, 25 Sep 2010 12:32:55 +0200 Alban Hertroys wrote: > On 24 Sep 2010, at 21:20, Bartłomiej Korupczyński wrote: > > > Hi guys, > > > > I've found some posts from 2007 about UPDATE/DELETE ... LIMIT N syntax > > and I'd like to raise it again. Current PostgreSQL of UPDATE/DELETE > > implement

Re: [GENERAL] UPDATE/DELETE with ORDER BY and LIMIT

2010-09-25 Thread Alban Hertroys
On 24 Sep 2010, at 21:20, Bartłomiej Korupczyński wrote: > Hi guys, > > I've found some posts from 2007 about UPDATE/DELETE ... LIMIT N syntax > and I'd like to raise it again. Current PostgreSQL of UPDATE/DELETE > implement RETURNING statement, so extending by ORDER and LIMIT would be > really u

[GENERAL] UPDATE/DELETE with ORDER BY and LIMIT

2010-09-24 Thread Bartłomiej Korupczyński
Hi guys, I've found some posts from 2007 about UPDATE/DELETE ... LIMIT N syntax and I'd like to raise it again. Current PostgreSQL of UPDATE/DELETE implement RETURNING statement, so extending by ORDER and LIMIT would be really useful. Let's say we need to reserve some kind of identifier for user.